Gurjeet Singh wrote:
On Tue, Sep 30, 2008 at 3:09 PM, Heikki Linnakangas <
[EMAIL PROTECTED]> 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?
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers