Re: speeding up pg_dump?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: me(at)alternize(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: speeding up pg_dump?
Date: 2005-12-27 05:56:05
Message-ID: 19905.1135662965@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

<me(at)alternize(dot)com> writes:
>> Me either. Do you have operations that are taking exclusive locks on
>> tables?

> there is one exclusive lock...

> transactionid | | | | | 42571885 |
> | | | 42571885 | 3680 | ExclusiveLock | t

Every transaction takes ExclusiveLock on its own transaction ID. That
in itself isn't an issue. You sure you don't see any rows with granted
= 'f' while pg_dump is running and everything seems blocked?

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message me 2005-12-27 06:10:23 Re: speeding up pg_dump?
Previous Message me 2005-12-27 05:39:44 Re: speeding up pg_dump?