Re: Index size increases after VACUUM FULL

Поиск
Список
Период
Сортировка
От Gurjeet Singh
Тема Re: Index size increases after VACUUM FULL
Дата
Msg-id 65937bea0809300447u6d2054e5x7688fbd45c0b7bdf@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Index size increases after VACUUM FULL  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Ответы Re: Index size increases after VACUUM FULL
Список pgsql-hackers
On Tue, Sep 30, 2008 at 4:49 PM, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> wrote:
Gurjeet Singh wrote:
On Tue, Sep 30, 2008 at 3:09 PM, Heikki Linnakangas <
heikki.linnakangas@enterprisedb.com> wrote:
That's normal. VACUUM FULL creates new index pointers for the tuples it
moves, which can lead to a bigger index. If it bothers, REINDEX will pack
the indexes tighter again.


That explains it... and yes, REINDEX did bring the index size back to
normal.

Would it make sense to mention this in docs of VACUUM FULL? Either at

http://www.postgresql.org/docs/8.3/static/routine-vacuuming.html

or at

http://www.postgresql.org/docs/8.3/static/sql-vacuum.html

Yeah, maybe. Want to suggest a wording?

VACUUM FULL may cause a noticeable increase in size of the indexes of the tables that are vacuumed; this is because the VACUUM operation makes new entries in the index for the tuples/rows that have just been moved.

OR

VACUUM FULL may cause a noticeable increase in size of the indexes, that are on the  tables being vacuumed; this is because the VACUUM operation makes new entries in the index for the tuples/rows that have just been moved.

Followed By:

An appropriate REINDEX command (REINDEX database|table|index ) can reduce the size of such indexes.


    I think it makes sense to put this on both the above mentioned URLs.

Best regards,
--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB      http://www.enterprisedb.com

Mail sent from my BlackLaptop device

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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Index size increases after VACUUM FULL
Следующее
От: "Gurjeet Singh"
Дата:
Сообщение: Re: FSM rewrite committed, loose ends