Re: speeding up pg_dump?

> Me either.  Do you have operations that are taking exclusive locks on
> tables?

there is one exclusive lock...

   locktype    | database | relation | page | tuple | transactionid |
classid | objid | objsubid | transaction | pid  |      mode       | granted

---------------+----------+----------+------+-------+---------------+---------+-------+----------+-------------+------+-----------------+---------
 relation      |  4131529 |    10342 |      |       |               |
|       |          |    42571885 | 3680 | AccessShareLock | t
 transactionid |          |          |      |       |      42571885 |
|       |          |    42571885 | 3680 | ExclusiveLock   | t
(2 rows)

but this lock is also present when restarting the db, so i guess this
shouldn't hurt?

VACUUM FULL takes around 15min...

- thomas