Re: Reindexdb - Mailing list pgsql-general

From Tom Lane
Subject Re: Reindexdb
Date
Msg-id 18747.1147392302@sss.pgh.pa.us
Whole thread Raw
In response to Re: Reindexdb  ("Carlos Oliva" <carlos@pbsinet.com>)
Responses Re: Reindexdb
List pgsql-general
"Carlos Oliva" <carlos@pbsinet.com> writes:
> In the mean time maybe I can ask you:  Does VACUUM FULL ANALYZE of a
> database would also reindex the user indexes of a database?  I am trying to
> eliminate index bloating.

VACUUM FULL not only doesn't do a REINDEX for you, it's more likely to
bloat the indexes than shrink them.

            regards, tom lane

pgsql-general by date:

Previous
From: "Bart Butell"
Date:
Subject: GUI Interface
Next
From: Kenneth Downs
Date:
Subject: Re: GUI Interface