Re: [PATCHES] pg_dump lock timeout - Mailing list pgsql-hackers

From Marko Kreen
Subject Re: [PATCHES] pg_dump lock timeout
Date
Msg-id e51f66da0807030115y2520ecbdie9d17f6312636f3@mail.gmail.com
Whole thread Raw
Responses Re: [PATCHES] pg_dump lock timeout  (daveg <daveg@sonic.net>)
List pgsql-hackers
On 5/11/08, daveg <daveg@sonic.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.

- It would be more polite to do SET LOCAL instead SET.
  (Eg. it makes safer to use pg_dump through pooler.)

- 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.

--
marko

pgsql-hackers by date:

Previous
From: Volkan YAZICI
Date:
Subject: Concurrent Restores
Next
From: Mark Cave-Ayland
Date:
Subject: Re: WIP patch: reducing overhead for repeat de-TOASTing