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
31473	Use PostgreSQL TRUNCATE … RESTART IDENTITY keyword to reset sequences in sql_flush()	Jon Dufresne	Jon Dufresne	"Rather than executing an additional query per truncated table, can truncate and reset sequences in a single query by using the `RESTART IDENTITY` syntax.

My project uses the `sql_flush()` operation internally and profiling shows that it can consume a large percentage of the runtime. Reducing the number of queries to one should help provide a small performance improvement. "	Cleanup/optimization	closed	Database layer (models, ORM)	dev	Normal	fixed			Ready for checkin	1	0	0	0	0	0