Skip site navigation (1) Skip section navigation (2)

Re: Replication

From: Will LaShell <will(at)lashell(dot)net>
To: Andrew Sullivan <andrew(at)libertyrms(dot)info>
Cc: PostgreSQL Admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Replication
Date: 2003-01-28 23:56:25
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
On Tue, 2003-01-28 at 14:12, Andrew Sullivan wrote:
> On Tue, Jan 28, 2003 at 09:59:52AM -0700, Will LaShell wrote:
> > What problems have people been having getting rserv to work at all?
> In 2001 I tested it for our anticipated load.  It worked for me, but
> it was not up to the kind of load that we were anticipating.  It was
> reasonable, however, and I was not able to break it; it just wasn't
> up to the load I had to plan for.  We also needed multi-salve
> replication.  We therefore did some work with PostgreSQL, Inc. to
> produce a new, somewhat better version of rserv.  That's what we
> still use in our production systems.
> So I have not had problems getting rserv to work, but it wasn't
> enough for us.  I wouldn't hesitate to recommend it to others,
> though: the strategy is sound, and if it meets your needs, it'll
> probably do fine (assuming it still works with 7.3; when I was
> testing, remember, 7.1.x was the released version).  I seem to recall
> keeping it busy with several hundred transactions per minute, but
> whether that was sustainable I don't know.
> A

I definitely agree with this analysis.  The biggest thing with getting
rserv to work fast, is using the right replication field id. We elected
to use a bigint, created an index only on it and treat it special. If I
get inspired I could post up some performance metrics if anyone cares to
be interested.

I have looked at eRserv in the past, the problem is the price. It's just
a bit high to convince the people here to use. Hopefully I can get them
to change their minds.


Will LaShell

In response to

pgsql-admin by date

Next:From: Marc G. FournierDate: 2003-01-28 23:57:46
Subject: Re: Replication
Previous:From: Will LaShellDate: 2003-01-28 23:51:51
Subject: Re: Replication

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group