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

From Alvaro Herrera
Subject Re: Index bloat in 7.2
Date
Msg-id 20041206161830.GD7455@dcc.uchile.cl
Whole thread Raw
In response to Re: Index bloat in 7.2  ("Julian Scarfe" <julian.scarfe@ntlworld.com>)
Responses Re: Index bloat in 7.2  (Julian Scarfe <julian.scarfe@ntlworld.com>)
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.

"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.)

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
Y una voz del caos me habló y me dijo
"Sonríe y sé feliz, podría ser peor".
Y sonreí. Y fui feliz.
Y fue peor.

pgsql-general by date:

Previous
From: "C G"
Date:
Subject: Re: triggers, transactions and locks
Next
From: Alvaro Herrera
Date:
Subject: Re: Performance tuning on RedHat Enterprise Linux 3