Re: Autovacuum vs statement_timeout

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.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support