pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-performance@postgresql.org
Subject: Re: VACUUMs take twice as long across all nodes
Date: Sun, 29 Oct 2006 11:43:19 -0500
Message-ID: <20061029164319.GG14585@phlogiston.dyndns.org> (raw)
In-Reply-To: <1162139073.7606.1.camel@andi-lap>
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>

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



view thread (17+ messages)  latest in thread

Message-ID: <20061029164319.GG14585@phlogiston.dyndns.org>
Permalink:  ../20061029164319.GG14585@phlogiston.dyndns.org/
Also on:    postgresql.org/message-id/20061029164319.GG14585@phlogiston.dyndns.org

 · 

reply
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 using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: ajs@crankycanuck.ca
  Subject: Re: VACUUMs take twice as long across all nodes
  In-Reply-To: <20061029164319.GG14585@phlogiston.dyndns.org>

* 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