Re: speeding up pg_dump?

Поиск
Список
Период
Сортировка
От
Тема Re: speeding up pg_dump?
Дата
Msg-id 007f01c60aac$3995f760$6402a8c0@iwing
обсуждение исходный текст
Ответ на speeding up pg_dump?  (<me@alternize.com>)
Список pgsql-novice
From: "Tom Lane" <tgl@sss.pgh.pa.us>
> 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?

yes. during a pg_dump, there are like 30 locks - all of then granted (t)

i'll set up pg8.1.1 tomorrow on a new server to check if its db/web or
server related...

best regards,
thomas




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

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