Re: Index bloat in 7.2

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 16:50:17
Message-ID: E8BC0026-47A6-11D9-87CB-00039359B9BA@ntlworld.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Mon, Dec 06, 2004 at 08:48:04AM -0000, Julian Scarfe wrote:
>
>> 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.

On 6 Dec 2004, at 16:18, Alvaro Herrera wrote:
>
> "Long enough" could be a minutes or seconds issue if you use Slony-I,
> I've heard ... (Of course you'd still need to fix your apps, which may
> take somewhat longer than that.)

A good point Alvaro, but I don't think Slony-I is compatible with 7.2,
which is the version I'm starting from. For upgrades from 7.3 onwards,
it's certainly a route worth considering.

Julian

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Eric E 2004-12-06 16:58:20 Auditing with shared username
Previous Message Robert Treat 2004-12-06 16:36:14 Re: pgFoundary?