Re: speeding up pg_dump?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: speeding up pg_dump?
Дата
Msg-id 19905.1135662965@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: speeding up pg_dump?  (<me@alternize.com>)
Список 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

В списке pgsql-novice по дате отправления:

Предыдущее
От:
Дата:
Сообщение: Re: speeding up pg_dump?
Следующее
От:
Дата:
Сообщение: Re: speeding up pg_dump?