Re: fatal error on 8.1 server

Поиск
Список
Период
Сортировка
От Russell Smith
Тема Re: fatal error on 8.1 server
Дата
Msg-id 4572426D.5000203@pws.com.au
обсуждение исходный текст
Ответ на Re: fatal error on 8.1 server  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Tom Lane wrote:
> Alvaro Herrera <alvherre@commandprompt.com> writes:
>
>> Tony Caduto wrote:
>>
>>> I did not have autovacuum turned on and I usually do a vacuumdb -z -a -f
>>> -q  each night but this one slipped through the cracks :-(
>>>
>
>
>> Strange -- autovacuum should have started an automatic database-wide
>> vacuum on that database, even if disabled.
>>
>
> We only added that in 8.2, no?  8.1 autovacuum would have forced the
> vacuum to occur, but only if it was enabled in postgresql.conf.
>
And in 8.2 it's only a per table vacuum that is required.  Is that
correct too?
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>
>
>


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

Предыдущее
От: Shane Ambler
Дата:
Сообщение: Re: named cache
Следующее
От:
Дата:
Сообщение: Re: select query not using index