Re: Autovacuum vs statement_timeout

On Wednesday 18 April 2007 11:30, Alvaro Herrera wrote:
> Robert Treat wrote:
> > On Tuesday 17 April 2007 20:54, Tom Lane wrote:
> > > I'm not excited about the other ones but I can see the argument for
> > > making pg_dump force the timeout to 0.
> >
> > Allowing pg_dump to run un-checked could also lead to problems such as
> > exceeding maintenence windows causing performance issues, or causing
> > trouble due to lock contention with ongoing pg_dumps.
>
> I have never ever seen a request to be able to control pg_dump and have
> it stop dumping if the time taken to dump exceeded a threshold.

Given that we already have the functionality, I suspect you wouldn't...

-- 
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL