From: | "John Lister" <john(dot)lister-ps(at)kickstone(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Cc: | <john(dot)lister-ps(at)kickstone(dot)co(dot)uk> |
Subject: | |
Date: | 2009-12-03 11:03:54 |
Message-ID: | C7EFE7FB137F41AEA754561E488BA3C3@squarepi.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
"Kevin Grittner" Kevin(dot)Grittner(at)wicourts(dot)gov wrote
>"John Lister" <john(dot)lister-ps(at)kickstone(dot)com> wrote:
> When you do a vacuum it marks the deleted rows as being usable
> again and I can see that it reports that "xxx index row versions
> were removed", however are these rows marked for reuse in an index
> in the same manner as they are in the table? I note that the docs
> say that vacuum full doesn't shrink indexes and that a reindex is
> recommended periodically, is this still true if the table is
> frequently vacuumed?
>VACUUM makes space in indexes available for re-use. I don't think
>that reindex is normally needed for recent releases, although I seem
>to remember hearing that it was needed in older versions. What
>version are you running?
Thanks for your reply. I'm using 8.3.8 (ubuntu).
I thought it would do, but couldn't see anything to confirm that and some of my indexes seem to grow disproportionately to the size of the tables, but I haven't studied it in detail yet - I was trying to increase performance on a number of tables that seem to be extremely bloated for some reason.
Thanks
--
Got needs? Get Goblin'! - http://www.pricegoblin.co.uk/
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2009-12-03 17:31:31 | Re: |
Previous Message | Kevin Grittner | 2009-12-02 17:55:55 | Re: question about vacuum and index bloat |