id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
3459	SET TIME ZONE called too often for postgresql_psycopg2 backend	Jack Moffitt <metajack@…>	Adrian Holovaty	"Analyzing our database logs I found that 25% of all traffic were calls to SET TIME ZONE.  This is currently called for every cursor when using the postgrsql_psycopg2 backend.  This only needs to be called when the connection is established.  All cursors will get the correct timezone if it is set in the connection.

I've attached a patch which calls SET TIME ZONE only on new connections.  This eliminates a lot of wasted database traffic and can result in a large performance gain for loaded systems using this backend."		closed	Database layer (models, ORM)	dev		fixed			Ready for checkin	1	0	0	0	0	0