Re: Bloated pg_shdepend_depender_index - Mailing list pgsql-admin

From Andy Shellam
Subject Re: Bloated pg_shdepend_depender_index
Date
Msg-id !&!AAAAAAAAAAAuAAAAAAAAALfqleqaijxJlxu+E5RYF+YBAJaQ0jfg6zBFp7poaER6UCkAAAGy3PcAABAAAABny9p8KUNnSIk/ZFDeNe+NAQAAAAA=@mailnetwork.co.uk
Whole thread Raw
In response to Re: Bloated pg_shdepend_depender_index  ("Jim C. Nasby" <jnasby@pervasive.com>)
Responses Re: Bloated pg_shdepend_depender_index  (Ola Sandbu <ola.sandbu@usit.uio.no>)
Re: Bloated pg_shdepend_depender_index  (Rafael Martinez <r.m.guerrero@usit.uio.no>)
List pgsql-admin
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.

QUOTE:
Uh, for many sites minutes of downtime would be a huge issue, let alone
hours.

Fortunately, you can use Slony to migrate between versions, greatly
reducing downtime.
END QUOTE


pgsql-admin by date:

Previous
From: "Gourish Singbal"
Date:
Subject: auto vacuuming
Next
From: "Andy Shellam"
Date:
Subject: Re: FW: Setting up of PITR system.