Re: Autovacuum and pg_largeobject

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Autovacuum and pg_largeobject
Дата
Msg-id 1278113349-sup-926@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Autovacuum and pg_largeobject  (Norberto Delle <betodelle@gmail.com>)
Список pgsql-general
Excerpts from Norberto Delle's message of vie jul 02 13:43:37 -0400 2010:

> As far as I know, It's not being locked. We use it to store digitalized
> documents
> and it's getting very big. I think the server is being turned off before
> it can complete
> an vacuum pass. The server is not kept on overnight.

Oh.  That's exceptional.  I think you'd be better served by scheduling a
manual vacuum sometime during the day -- and probably with lower
cost_delay parameters, so that it takes less time to complete.

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

Предыдущее
От: "Jose Torres"
Дата:
Сообщение: Need Windows 2008 support and old installer kind
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: C-Functions using SPI - Missing Magic Block