Re: Plans for 8.2? - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Plans for 8.2?
Date
Msg-id 20060113084902.GA89447@winnie.fuhr.org
Whole thread Raw
In response to Plans for 8.2?  ("H.J. Sanders" <hjs@rmax.nl>)
Responses Re: Plans for 8.2?  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Nico Grubert
Date:
Subject: Re: How to reset a sequence so it will start with 1 again?
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Locales problems with debian sarge3.1