Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Patch for Prevent pg_dump/pg_restore from being affected by statement_timeout

From: "Alex Hunsaker" <badalex(at)gmail(dot)com>
To: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, "Pg Patches" <pgsql-patches(at)postgresql(dot)org>
Cc: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, "Andrew Dunstan" <andrew(at)dunslane(dot)net>, "Greg Sabino Mullane" <greg(at)turnstep(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Patch for Prevent pg_dump/pg_restore from being affected by statement_timeout
Date: 2008-04-16 23:21:35
Message-ID: 34d269d40804161621q8aa544dh6d10ab7a2c934d9e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
On Wed, Apr 16, 2008 at 4:54 PM, Alvaro Herrera
<alvherre(at)commandprompt(dot)com> wrote:
> Joshua D. Drake escribió:
>
> > That is an interesting idea. Something like:
>  >
>  > pg_restore -E "SET STATEMENT_TIMEOUT=0; SET MAINTENANCE_WORK_MEM=1G" ?
>
>  We already have it -- it's called PGOPTIONS.
>

Ok but is not the purpose of the patch to turn off statement_timeout
by *default* in pg_restore/pg_dump?

Here is an updated patch for I posted above (with the command line
option --use-statement-timeout) for pg_dump and pg_restore.

(sorry If I hijacked your patch Josh :) )

Attachment: pg_dump_restore_statement_timeout.diff
Description: application/octet-stream (5.2 KB)

In response to

Responses

pgsql-hackers by date

Next:From: Brendan JurdDate: 2008-04-16 23:37:33
Subject: Re: printTable API (was: Show INHERIT in \du)
Previous:From: Stephen DenneDate: 2008-04-16 23:19:49
Subject: Re: count(*) performance improvement ideas

pgsql-patches by date

Next:From: Brendan JurdDate: 2008-04-16 23:37:33
Subject: Re: printTable API (was: Show INHERIT in \du)
Previous:From: Alvaro HerreraDate: 2008-04-16 22:54:49
Subject: Re: Patch for Prevent pg_dump/pg_restore from beingaffected by statement_timeout

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group