Re: Index bloat in 7.2 - Mailing list pgsql-general

From Julian Scarfe
Subject Re: Index bloat in 7.2
Date
Msg-id E8BC0026-47A6-11D9-87CB-00039359B9BA@ntlworld.com
Whole thread Raw
In response to Re: Index bloat in 7.2  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List 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


pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re: pgFoundary?
Next
From: Eric E
Date:
Subject: Auditing with shared username