Re: detection of VACUUM in progress

Поиск
Список
Период
Сортировка
От Bohdan Linda
Тема Re: detection of VACUUM in progress
Дата
Msg-id 20050831121847.GB27986@bafster.chello.upc.cz
обсуждение исходный текст
Ответ на Re: detection of VACUUM in progress  (Ben-Nes Yonatan <da@canaan.co.il>)
Ответы Re: detection of VACUUM in progress  (Ben-Nes Yonatan <da@canaan.co.il>)
Re: detection of VACUUM in progress  (Scott Marlowe <smarlowe@g2switchworks.com>)
Список pgsql-general
>
> From the postgresql manual
> http://www.postgresql.org/docs/8.0/interactive/maintenance.html :
> " The standard form of VACUUM is best used with the goal of maintaining
> a fairly level steady-state usage of disk space. If you need to return
> disk space to the operating system you can use VACUUM FULL ? but what's
> the point of releasing disk space that will only have to be allocated
> again soon? Moderately frequent standard VACUUM runs are a better
> approach than infrequent VACUUM FULL runs for maintaining
> heavily-updated tables."
>
> From this I conclude that an ordinary VACUUM is sufficent to your
> purpose cause you insert/delete almost the same amount of data daily.
>
> But then again I can be mistaken so if anyone can back me up here or
> throw the manual on me will be nice ;P


If I vacuum only the table, the records may be used by new lines, that is
fine. Problem is, that when creating select on such table, it takes more
pages to be read from the IO (it will read laso deleted rows) thus the
select will last a bit longer.

regards,
Bohdan

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

Предыдущее
От: Joost Kraaijeveld
Дата:
Сообщение: Re: How do I copy part of table from db1 to db2 (and
Следующее
От: Thomas Pundt
Дата:
Сообщение: Re: [SQL] How do I copy part of table from db1 to db2 (and