Re: Reindex vs Vacuum analyze - Mailing list pgsql-admin

From Tom Lane
Subject Re: Reindex vs Vacuum analyze
Date
Msg-id 14106.1036196733@sss.pgh.pa.us
Whole thread Raw
In response to Re: Reindex vs Vacuum analyze  (Vincent Janelle <random@goblinstudios.com>)
List pgsql-admin
Vincent Janelle <random@goblinstudios.com> writes:
> when entries are deleted from an table they're not deleted from the
> index, and vacuum doesn't clean them up.

This is entirely false.

There is a problem with recovering space in an index if the range of
indexed values changes over time.  But claiming that we don't delete
index entries is just plain wrong.

            regards, tom lane

pgsql-admin by date:

Previous
From: Naomi Walker
Date:
Subject: Re: loading and unloading rows
Next
From: Bruce Momjian
Date:
Subject: Re: loading and unloading rows