Re: More 8.2 client issues (Was: [Slow dump?)

From: Erik Jones <erik(at)myemma(dot)com>
To: Erik Jones <erik(at)myemma(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: More 8.2 client issues (Was: [Slow dump?)
Date: 2007-01-05 18:02:04
Message-ID: 459E929C.9000607@myemma.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Erik Jones wrote:
> Tom Lane wrote:
>> Erik Jones <erik(at)myemma(dot)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(at)myemma(dot)com>
software development
emma(r)

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Reid Thompson 2007-01-05 18:15:44 Re: PostgreSQL to host e-mail?
Previous Message Mikael Carneholm 2007-01-05 11:47:08 Re: Partitioning