From: Erik Jones <erik@myemma.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
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 11:58:16 -0600
Message-ID: <459BEEB8.5050405@myemma.com> (raw)
In-Reply-To: <13359.1167844898@sss.pgh.pa.us>
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>
<13359.1167844898@sss.pgh.pa.us>
Tom Lane wrote:
> 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?
>
That's a good idea, but first I'll still need to run it by my sysadmin
wrt space -- our dump files are around 22GB when we can let them finish
these days. We do have plans to move off of the dump to a snapshot
backup strategy that will eventually lead to a PITR warm-standby setup
but, first, we want to make sure we have a stable, fast, up-to-date
server -- our web servers are still connecting to the db via 8.1.4
client libs as given what we've seen of the track record for 8.2. client
libs on our setup, we're bit reticent to move the rest of the
application over. While I wait to see what we can do about logging
everything during the dump I'll probably build 8.2 on a remote linux
machine and see how connecting via those tools compares.
--
erik jones <erik@myemma.com>
software development
emma(r)
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: erik@myemma.com, tgl@sss.pgh.pa.us, guillaume.smet@gmail.com
Subject: Re: More 8.2 client issues (Was: [Slow dump?)
In-Reply-To: <459BEEB8.5050405@myemma.com>
* 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