From: | daveg <daveg(at)sonic(dot)net> |
---|---|
To: | Marko Kreen <markokr(at)gmail(dot)com> |
Cc: | pgsql-patches(at)postgresql(dot)org, hari(at)efrontier(dot)com, Postgres Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [PATCHES] pg_dump lock timeout |
Date: | 2008-07-03 12:55:01 |
Message-ID: | 20080703125501.GS866@sonic.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
On Thu, Jul 03, 2008 at 11:15:10AM +0300, Marko Kreen wrote:
> On 5/11/08, daveg <daveg(at)sonic(dot)net> wrote:
> > Attached is a patch to add a commandline option to pg_dump to limit how long
> > pg_dump will wait for locks during startup.
>
> My quick review:
>
> - It does not seem important enough to waste a short option on.
> Having only long option should be enough.
Agreed. I'll change it.
> - It would be more polite to do SET LOCAL instead SET.
> (Eg. it makes safer to use pg_dump through pooler.)
Also agreed. Thanks.
> - The statement_timeout is set back with "statement_timeout = default"
> Maybe it would be better to do "= 0" here? Although such decision
> would go outside the scope of the patch, I see no sense having
> any other statement_timeout for actual dumping.
I'd prefer to leave whatever policy is otherwise in place alone. I can see
use cases for either having or not having a timeout for pg_dump, but it does
seem outside the scope of this patch.
Thanks for you review and comments.
-dg
--
David Gould daveg(at)sonic(dot)net 510 536 1443 510 282 0869
If simplicity worked, the world would be overrun with insects.
From | Date | Subject | |
---|---|---|---|
Next Message | Aaron Spiteri | 2008-07-03 13:15:33 | Command execution |
Previous Message | Gregory Stark | 2008-07-03 12:54:29 | Re: Resolving polymorphic functions with relateddatatypes |
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2008-07-03 13:11:30 | Re: EXPLAIN progress info |
Previous Message | Pavan Deolasee | 2008-07-03 11:50:52 | Re: page macros cleanup |