Re: Index bloat problem in 7.4 - Mailing list pgsql-hackers

From Markus Schaber
Subject Re: Index bloat problem in 7.4
Date
Msg-id 4512DC60.8000306@logix-tt.com
Whole thread Raw
In response to Index bloat problem in 7.4  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: Index bloat problem in 7.4
List pgsql-hackers
Hi, Dave,

Dave Cramer wrote:
> I am aware that more recent versions > 8.x have fixed this problem, I
> checked the 7.4 release notes but can't see if any of the fixes made it
> into 7.4.

Usually, only critical data loss and security fixes are put into the
minor updates (e. G. 7.4.0 to 7.4.13). So, if it's not in the release
notes, it is unlikely that it dit make it into the 7.4 releases.

You may try backporting it yourself, or use a cronjob or such issuing
regular REINDEX commands during the night (or whenever you have idle hours).

HTH;
Markus

--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Release Notes: Major Changes in 8.2
Next
From: Markus Schaber
Date:
Subject: Re: Cause of moving-target FSM space-needed reports