Re: Load spikes on 8.1.11 - Mailing list pgsql-hackers

From Andrew Sullivan
Subject Re: Load spikes on 8.1.11
Date
Msg-id 20080721195902.GE32548@commandprompt.com
Whole thread Raw
In response to Re: Load spikes on 8.1.11  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
Responses Re: Load spikes on 8.1.11  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
List pgsql-hackers
On Sat, Jul 19, 2008 at 07:09:46AM +0530, Gurjeet Singh wrote:

> Will try this option, at least in the next schema upgrade or when setting up
> Slony.

As I've already suggested, however, if you try to set up slony on a
loaded database, you're going to see all manner of problems.  Slony
takes some heavy-duty locks when it does its setup work.  It's
designed that you should have an application outage for this sort of
work.  Please see previous discussion on the Slony mailing list.

A
-- 
Andrew Sullivan
ajs@commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Do we really want to migrate plproxy and citext into PG core distribution?
Next
From: Robert Lor
Date:
Subject: Re: Review: DTrace probes (merged version)