Re: Index bloat in 7.2

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Julian Scarfe <julian(dot)scarfe(at)ntlworld(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Index bloat in 7.2
Date: 2004-12-06 16:18:30
Message-ID: 20041206161830.GD7455@dcc.uchile.cl
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.

"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[(at)]dcc(dot)uchile(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2004-12-06 16:31:01 Re: Performance tuning on RedHat Enterprise Linux 3
Previous Message C G 2004-12-06 16:06:42 Re: triggers, transactions and locks