Vacuuming DVs with few/no updates?

Поиск
Список
Период
Сортировка
От Preston
Тема Vacuuming DVs with few/no updates?
Дата
Msg-id 1044480808.3e418328aca17@mail.idl.net.au
обсуждение исходный текст
Ответы Re: Vacuuming DVs with few/no updates?
Список pgsql-admin
Hi all,

Just wondering about how useful the vacuumdb functionality is for a database
that pretty much only ever gets inserts/selects.

I've got a database that is intended for next-to-no deletion of records, which
is where I see the vacuum facility mostly intended for. I.e., while there'll be
the occasional record edits, these edits will primarily be of the form of
adjusting integer records (and therefore shouldn't adjust any space requirements
for a row).

I'm thinking that with this database I'll configure vacuumdb to only run once a
month or so. But before I do that I want to make sure I'm not missing some other
important functionality that it does...

Cheers,

-Preston de Guise.

--
Oops.

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

Предыдущее
От: Matias Monteverde
Дата:
Сообщение:
Следующее
От: "Chris White"
Дата:
Сообщение: Re: Duplicate indexes found in the postgres Database