On Fri, Jan 13, 2006 at 09:30:22AM +0100, H.J. Sanders wrote: > Just one request that would make the transition from another > great database to PostgreSQL a lot easier: > > SET LOCK MODE TO WAIT n > > n = the max.time in second to wait.
Will statement_timeout suffice? http://www.postgresql.org/docs/8.1/interactive/runtime-config-client.html > For Christmas 2007 I like: > > statistics about how many sequential scans where have been for a given table. Is pg_stat_{all,sys,user}_tables.seq_scan not what you're looking for? http://www.postgresql.org/docs/8.1/interactive/monitoring-stats.html -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
