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