Re: Index bloat problem in 7.4

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Index bloat problem in 7.4
Date: 2006-09-21 18:39:28
Message-ID: 4512DC60.8000306@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Markus Schaber 2006-09-21 18:44:25 Re: Cause of moving-target FSM space-needed reports
Previous Message Josh Berkus 2006-09-21 17:34:29 Re: Release Notes: Major Changes in 8.2