Re: Vacuuming of indexes on tables. - Mailing list pgsql-general

From Tom Lane
Subject Re: Vacuuming of indexes on tables.
Date
Msg-id 12663.1145368204@sss.pgh.pa.us
Whole thread Raw
In response to Vacuuming of indexes on tables.  (elein <elein@varlena.com>)
Responses Re: Vacuuming of indexes on tables.  (elein <elein@varlena.com>)
List pgsql-general
elein <elein@varlena.com> writes:
> Much later in the day, a vacuum analyze of the
> db showed that all of the indexes for that table
> required significant vacuuming, although the
> table did not.

What do you mean by that exactly?  If it's just that the index pages
emptied by one VACUUM aren't actually recycled till the next one,
that's by design.

            regards, tom lane

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Syntax Help Requested -- RESOLVED
Next
From: Alexander Scholz
Date:
Subject: Query to check existence of stored procedure?