Re: [OT] Slony (initial) Replication - Slow

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Chris Browne <cbbrowne(at)acm(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [OT] Slony (initial) Replication - Slow
Date: 2008-01-04 21:11:40
Message-ID: 20080104211140.GJ16708@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message beer@cmu.edu 2008-01-04 21:12:56 Re: data volume resizing and large objects
Previous Message Tom Lane 2008-01-04 20:42:30 Re: data volume resizing and large objects