From: Erik Jones <erik@myemma.com>
To: Erik Jones <erik@myemma.com>
Cc: 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: Fri, 05 Jan 2007 12:02:04 -0600
Message-ID: <459E929C.9000607@myemma.com> (raw)
In-Reply-To: <459BFD1C.80707@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>
<13359.1167844898@sss.pgh.pa.us>
<459BEEB8.5050405@myemma.com>
<16137.1167848799@sss.pgh.pa.us>
<459BFD1C.80707@myemma.com>
Erik Jones wrote:
> Tom Lane wrote:
>> Erik Jones <erik@myemma.com> writes:
>>
>>> 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.
>>>
>>
>> Given that we're now speculating about regex problems, you could do a
>> test run of "pg_dump -s" with logging enabled; that shouldn't take an
>> unreasonable amount of time or space.
>>
>> regards, tom lane
>>
> Sounds like a post-lunch plan! By the way, even though this isn't
> even solved yet, thank you for all of your help!
>
Ok, this ended up taking a bit longer to get to due to the fact that
we've been building indexes on our user tables off and on for the last
few days. But, I'm back on it now. Here is my general plan of
action: I'm going to do a schema dump of the pg_catalog schema from a
fresh, clean 8.2 install and, tomorrow night after I do the same against
the db we've been having issues with, diff the two to see if there are
any glaring discrepancies. While running the dump from the live db I
will have statement logging on for the dump, are there any queries or
query lengths that I should pay particular attention to?
--
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: <459E929C.9000607@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