Re: Vacuuming of indexes on tables.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: elein <elein(at)varlena(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Vacuuming of indexes on tables.
Date: 2006-04-18 13:50:04
Message-ID: 12663.1145368204@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

elein <elein(at)varlena(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nikolay Samokhvalov 2006-04-18 14:06:39 Re: Query to check existence of stored procedure?
Previous Message Rich Shepard 2006-04-18 13:02:01 Re: Syntax Help Requested -- RESOLVED