| From: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Tuning |
| Date: | 2008-04-07 17:39:33 |
| Message-ID: | 20080407173933.GA7301@crankycanuck.ca |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Mon, Apr 07, 2008 at 12:45:38PM -0400, Chris Browne wrote:
> versions of PostgreSQL. e.g. - with v7.2, there were patterns of
> updates that would leave portions of indexes not usable, but the issue
> was rectified in ~7.4, and people have not been observing problems
> relating to this former scenario.
There remain use patterns that will leave the indexes in pretty bad shape.
This is an inherent limiation with btrees, though -- if you just unbalanced
the tree with a large number of deletes, there's nothing you can do except
REINDEX.
A
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mario Ferloni | 2008-04-07 20:53:08 | Re: Windows max concurrent connections |
| Previous Message | Chris Browne | 2008-04-07 16:45:38 | Re: Tuning |