Re: Bloated pg_shdepend_depender_index - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Bloated pg_shdepend_depender_index
Date
Msg-id 1143580500.3625.92.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: Bloated pg_shdepend_depender_index  (Rafael Martinez <r.m.guerrero@usit.uio.no>)
Responses Re: Bloated pg_shdepend_depender_index
List pgsql-admin
On Tue, 2006-03-28 at 13:51, Rafael Martinez wrote:
> On Tue, 2006-03-28 at 12:09 -0600, Jim C. Nasby wrote:
>
> >
> > Fortunately, you can use Slony to migrate between versions, greatly
> > reducing downtime.
>
> Yes, this is true, but the problem is that if the database is 'big' and
> running in an expensive system you need to double your investment only
> for the upgrade.
>
> I am sure we can find another way of doing this that is easier and
> faster.

Any large, production system should already have replication in place.

If not, you're taking your chances with that big system that make any
investment questionable.  If downtime is a real problem.

pgsql-admin by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Feedback on auto-pruning approach
Next
From: "Salem Berhanu"
Date:
Subject: postgres and persistant connections (using Apache::DBI)