Re: Vaccum and 24/7/365 database

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Vaccum and 24/7/365 database
Дата
Msg-id Pine.LNX.4.30.0201091117560.734-100000@peter.localdomain
обсуждение исходный текст
Ответ на Vaccum and 24/7/365 database  (Jean-Christophe ARNU <jc.arnu@free.fr>)
Список pgsql-admin
Jean-Christophe ARNU writes:

>     we use postgresql 7.2 for a data logging/supervisor application running
> 24 hours a day, 7 days a week and 365 (and 6 hours) a year. Data are
> inserted/deleted/updated each 1,5 minutes and for performance reason we
> have to vacuum each day some tables. The problem is that vacuum stops
> inserts, updates and deletes for the table it performs

As of 7.2, this is no longer true.  I recommend you read section 8.2 of
the Administrator's Guide.

--
Peter Eisentraut   peter_e@gmx.net


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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Vaccum and 24/7/365 database
Следующее
От: Trevor Astrope
Дата:
Сообщение: Performance Tuning