Quick Links

Re: Reindexdb

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	"Carlos Oliva" <carlos(at)pbsinet(dot)com>
Cc:	"'Joshua D(dot) Drake'" <jd(at)commandprompt(dot)com>, pgsql-general(at)postgresql(dot)org
Subject:	Re: Reindexdb
Date:	2006-05-12 00:05:02
Message-ID:	18747.1147392302@sss.pgh.pa.us
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

"Carlos Oliva" <carlos(at)pbsinet(dot)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

In response to

Re: Reindexdb at 2006-05-11 15:57:48 from Carlos Oliva

Responses

Re: Reindexdb at 2006-05-12 12:26:40 from Carlos

Browse pgsql-general by date

	From	Date	Subject
Next Message	Kenneth Downs	2006-05-12 01:08:49	Re: GUI Interface
Previous Message	Joshua D. Drake	2006-05-11 23:59:59	Re: [PERFORM] Arguments Pro/Contra Software Raid