Re: Autovacuum vs statement_timeout

Поиск
Список
Период
Сортировка
От Robert Treat
Тема Re: Autovacuum vs statement_timeout
Дата
Msg-id 200704181251.48624.xzilla@users.sourceforge.net
обсуждение исходный текст
Ответ на Re: Autovacuum vs statement_timeout  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: utf8 COPY DELIMITER?
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Background LRU Writer/free list