Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group