Re: VACUUM

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: VACUUM
Дата
Msg-id 20021120130438.B8903@mail.libertyrms.com
обсуждение исходный текст
Ответ на Re: VACUUM  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
On Thu, Nov 14, 2002 at 05:18:06PM -0500, Tom Lane wrote:
>
> The business about "you must vacuum at least every billion transactions"
> is a different issue.  Either plain or full vacuum will satisfy that
> requirement.

Note, also, that it is _every_ table needs to be vacuumed in that
billion transaction period, but it is nevertheless probable that some
of your tables will not need to be vacuumed as often as others.  For
efficiency's sake, therefore, you may want to vacuum different tables
at different times.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


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

Предыдущее
От: Luis Sousa
Дата:
Сообщение: Logrotate
Следующее
От: "Tim Lynch"
Дата:
Сообщение: crash help, pgsql 7.2.1 on RH7.3