Re: [OT] Slony (initial) Replication - Slow - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: [OT] Slony (initial) Replication - Slow
Date
Msg-id 20080104211140.GJ16708@alvh.no-ip.org
Whole thread Raw
In response to Re: [OT] Slony (initial) Replication - Slow  (Chris Browne <cbbrowne@acm.org>)
Responses Re: [OT] Slony (initial) Replication - Slow  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-general
Chris Browne wrote:

> In contrast, Slony-I regenerates all the indexes on a given table in a
> "one swell foop" fashion, which might be expected to allow cacheing to
> provide a bit better performance than you could get with "pg_dump |
> psql".

I'm left wondering whether the swoop is actually fell.  I imagine most
people would not survive an elephant herd, or slony, turning fell.  Now,
swooping elephants must be an interesting sight.  If pigs can fly ...

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: data volume resizing and large objects
Next
From: "beer@cmu.edu"
Date:
Subject: Re: data volume resizing and large objects