From: Tom Lane <tgl@sss.pgh.pa.us>
To: Erik Jones <erik@myemma.com>
Cc: Guillaume Smet <guillaume.smet@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: More 8.2 client issues (Was: [Slow dump?)
Date: Wed, 03 Jan 2007 12:21:38 -0500
Message-ID: <13359.1167844898@sss.pgh.pa.us> (raw)
In-Reply-To: <459BE4BB.4070601@myemma.com>
References: <459AD5A8.7030102@myemma.com>
<22512.1167779361@sss.pgh.pa.us>
<459BD61C.3030202@myemma.com>
<11617.1167841479@sss.pgh.pa.us>
<459BDC98.8030008@myemma.com>
<1d4e0c10701030850h78f19e74hfa7c25c01ded9a61@mail.gmail.com>
<459BE4BB.4070601@myemma.com>
Erik Jones <erik@myemma.com> writes:
> Guillaume Smet wrote:
>> Could you set log_min_duration_statement=0 on your server and enable
> Heh, unfortunately, setting log_min_duration_statement=0 would be a
> total last resort as the last we counted (2 months ago) we were doing
> approximately 3 million transactions per hour.
Do it just for the pg_dump:
export PGOPTIONS="--log_min_duration_statement=0"
pg_dump ...
I don't think that the regex issue explains pg_dump being slow,
unless perhaps you are making use of the table-selection switches?
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, erik@myemma.com, guillaume.smet@gmail.com
Subject: Re: More 8.2 client issues (Was: [Slow dump?)
In-Reply-To: <13359.1167844898@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox