Re: Autovacuum does not stay turned off

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: Autovacuum does not stay turned off
Дата
Msg-id 20080826162144.GX10936@commandprompt.com
обсуждение исходный текст
Ответ на Autovacuum does not stay turned off  (Jerry Champlin <jchamplin@absolute-performance.com>)
Список pgsql-performance
Дерево обсуждения 
On Tue, Aug 26, 2008 at 09:27:48AM -0600, Jerry Champlin wrote:
>
> Does anyone know what will cause this bahavior for autovacuum?

You're probably approaching the wraparound limit in some database.

If you think you can't afford the overhead when users are accessing
the system, when are you vacuuming?

A

--
Andrew Sullivan
ajs@commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/

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

Предыдущее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: Autovacuum does not stay turned off
Следующее
От: "Frank Joerdens"
Дата:
Сообщение: Query w empty result set with LIMIT orders of magnitude slower than without