Re: Vacuum and Transactions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Vacuum and Transactions
Дата
Msg-id 8394.1128438618@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Vacuum and Transactions  (Rod Taylor <pg@rbt.ca>)
Ответы Re: Vacuum and Transactions  (Hannu Krosing <hannu@skype.net>)
Список pgsql-hackers
Rod Taylor <pg@rbt.ca> writes:
> The catch is that there are some other very active structures (like
> pg_listener for Slony) which after a couple of hours without vacuuming
> will quickly have the DB at an unreasonably high load (low tens) which
> seems to all but halt the vacuum on the large structure.

Yeah.  We desperately need to reimplement listen/notify :-( ... that
code was never designed to handle high event rates.
        regards, tom lane


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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: [PERFORM] A Better External Sort?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Inherited indexes.