| From: | "Julian Scarfe" <julian(dot)scarfe(at)ntlworld(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Index bloat in 7.2 |
| Date: | 2004-12-06 08:48:04 |
| Message-ID: | 089a01c4db70$4e34cdc0$0600a8c0@Wilbur |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
From: "Christopher Browne" <cbbrowne(at)acm(dot)org>
> The "empty pages not reclaimed" problem is something that did indeed
> get fixed in the post-7.2 days. I _think_ it was 7.4, but it might
> have been 7.3.
> In short, 7.4.x is indeed a good resolution to your issue.
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>
> That's exactly what I'd expect ...
Thanks both.
So it sounds like:
a) the issue is controllable with a regular (and in our case, just
occasional) reindex without any long term negative consequences
b) Only a dump-restore major version upgrade (which we'll do next time we
can take the system out for long enough) will avoid the issue.
Julian
| From | Date | Subject | |
|---|---|---|---|
| Next Message | peter pilsl | 2004-12-06 09:05:16 | select single entry and its neighbours using direct-acess to index? |
| Previous Message | Richard Huxton | 2004-12-06 08:25:20 | Re: Older Windows versions |