Date: Sun, 29 Oct 2006 11:43:19 -0500
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-performance@postgresql.org
Subject: Re: VACUUMs take twice as long across all nodes
Message-ID: <20061029164319.GG14585@phlogiston.dyndns.org>
References: <20196.1161874041@sss.pgh.pa.us>
	<20061026160609.5e94e581.gdh@laterooms.com>
	<20061026191728.GD26892@nasby.net>
	<20061026213556.174bd7b5.gdh@laterooms.com>
	<20061026220937.GA6866@phlogiston.dyndns.org>
	<20061027102025.8183c5d9.gdh@laterooms.com>
	<20061029145825.GB14585@phlogiston.dyndns.org>
	<20061029150826.80afe324.gdh@laterooms.com>
	<20061029153404.GF14585@phlogiston.dyndns.org>
	<1162139073.7606.1.camel@andi-lap>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <1162139073.7606.1.camel@andi-lap>
User-Agent: Mutt/1.5.9i

On Sun, Oct 29, 2006 at 05:24:33PM +0100, Andreas Kostyrka wrote:
> Actually, you need to get the schema from the master node, and can take
> the data from a slave. In mixing dumps like that, you must realize that
> there are two seperate parts in the schema dump: "table definitions" and
> "constraints". Do get a restorable backup you need to put the table
> definitions stuff before your data, and the constraints after the data
> copy.

This will work, yes, but you don't get a real point-in-time dump this
way.  (In any case, we're off the -performance charter now, so if
anyone wants to pursue this, I urge you to take it to the Slony
list.)

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
Windows is a platform without soap, where rats run around 
in open sewers.
		--Daniel Eran