Re: Bloated pg_shdepend_depender_index

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Rafael Martinez <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>
Cc: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Bloated pg_shdepend_depender_index
Date: 2006-03-28 21:15:00
Message-ID: 1143580500.3625.92.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Salem Berhanu 2006-03-28 22:26:45 postgres and persistant connections (using Apache::DBI)
Previous Message Thomas F. O'Connell 2006-03-28 20:31:30 Remote On-line Backup