Vacuum full

Поиск
Список
Период
Сортировка
От Andrew Bartley
Тема Vacuum full
Дата
Msg-id 003a01c28536$9f4395d0$3200a8c0@abartleypc
обсуждение исходный текст
Список pgsql-general

We are using postgres 7.2

 

Can anyone tell me what the ramifications are if I do not vacuum full the whole DB?

 

Say if I was to selectively vacuum all of the PG tables, and only some of the Application tables.

 

We have a number of tables that are effectively archive type tables.  They are large, but do not change. If

I was to vacuum these tables on a regular basis, it would add a significant portion of time to the housekeeping process.

 

Thanks
 
Andrew
 
 
 
 

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Buffers and MacOS X
Следующее
От: Justin Clift
Дата:
Сообщение: Re: Vacuum full