From: Rafael Martinez <r.m.guerrero@usit.uio.no>
To: andy.shellam@mailnetwork.co.uk
Cc: 'Jim C. Nasby' <jnasby@pervasive.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Bloated pg_shdepend_depender_index
Date: Wed, 29 Mar 2006 18:56:56 +0200
Message-ID: <1143651416.18329.66.camel@linux.site> (raw)
In-Reply-To: <!&!AAAAAAAAAAAuAAAAAAAAALfqleqaijxJlxu+E5RYF+YBAJaQ0jfg6zBFp7poaER6UCkAAAGy3PcAABAAAABny9p8KUNnSIk/ZFDeNe+NAQAAAAA=@mailnetwork.co.uk>
References: <!&!AAAAAAAAAAAuAAAAAAAAALfqleqaijxJlxu+E5RYF+YBAJaQ0jfg6zBFp7poaER6UCkAAAGy3PcAABAAAABny9p8KUNnSIk/ZFDeNe+NAQAAAAA=@mailnetwork.co.uk>
On Wed, 2006-03-29 at 13:16 +0100, Andy Shellam wrote:
> This is true, but you could run the new version on the same server/different
> port to the current version, and do a simultaneous dump/restore without
> having to use extra disk space, or taking your production database offline -
> then you can schedule a time to kill the old one, re-assign the port on the
> new one and bring it up - would take about 30 seconds, and this could be
> done at a time when traffic was at its lowest.
Running the new version on another port in the samme server does not
help much. You have to initialize the new version to use new data
partitions (so you need the double of the disk space you have in
production.
Another minus is that this works only in a 'read only' database, all the
updates from you start the dump/restore process until you
kill/re-assign/start again won't be in the new version (and this can be
a lot of data in a busy/large system)
--
Rafael Martinez, <r.m.guerrero@usit.uio.no>
Center for Information Technology Services
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: r.m.guerrero@usit.uio.no, andy.shellam@mailnetwork.co.uk, jnasby@pervasive.com
Subject: Re: Bloated pg_shdepend_depender_index
In-Reply-To: <1143651416.18329.66.camel@linux.site>
References: <!&!AAAAAAAAAAAuAAAAAAAAALfqleqaijxJlxu+E5RYF+YBAJaQ0jfg6zBFp7poaER6UCkAAAGy3PcAABAAAABny9p8KUNnSIk/ZFDeNe+NAQAAAAA=@mailnetwork.co.uk> <1143651416.18329.66.camel@linux.site>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox