| 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: | Whole Thread | Raw Message | 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
| 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? |