Re: speeding up pg_dump? - Mailing list pgsql-novice

<me@alternize.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