Postgres Pro
Downloads
Home   >   mailing lists

Re: Index bloat problem? - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Index bloat problem?
Date
Msg-id 200504211022.03541.josh@agliodbs.com
Whole thread Raw
In response to Index bloat problem?  (Bill Chandler <billybobc1210@yahoo.com>)
Responses Re: Index bloat problem?  (Alex Turner <armtuk@gmail.com>)
List pgsql-performance
Tree view 
Bill,

> What about if an out-of-the-ordinary number of rows
> were deleted (say 75% of rows in the table, as opposed
> to normal 5%) followed by a 'VACUUM ANALYZE'?  Could
> things get out of whack because of that situation?

Yes.  You'd want to run REINDEX after and event like that.  As you should now.

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: Bill Chandler
Date:
Subject: Index bloat problem?
Next
From: Josh Berkus
Date:
Subject: Re: How can an index be larger than a table