Re: Autovacuum vs statement_timeout

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Autovacuum vs statement_timeout
Дата
Msg-id 200803112036.m2BKaLU22844@momjian.us
обсуждение исходный текст
Ответ на Re: Autovacuum vs statement_timeout  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-hackers
Joshua D. Drake wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> On Tue, 11 Mar 2008 16:17:53 -0400 (EDT)
> Bruce Momjian <bruce@momjian.us> wrote:
> 
> > Greg Sabino Mullane wrote:
> > > > Particularly consider using psql to restore a pg_dump
> > > > dump --- are we going to add "SET statement_timeout=0"
> > > > to the pg_dump file?
> > > 
> > > I hope not. That should be the user's choice.
> > 
> > Would anyone want to limit the load time for pg_dump?   I can hardly
> > see why.
> 
> I have to agree with Bruce here. You restore a backup because your
> hosed something or you are building a dev environment. These are both
> boolean results that should end in TRUE :)

But maybe this brings up that people just shouldn't put
statement_timeout in postgresql.conf, and if they do, they deserve what
they get.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://postgres.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Autovacuum vs statement_timeout
Следующее
От: "Stephen Denne"
Дата:
Сообщение: Re: Estimating geometric distributions