Re: Synch Replication - Mailing list pgsql-hackers

From Czichy, Thoralf (NSN - FI/Helsinki)
Subject Re: Synch Replication
Date
Msg-id D4D6DEF9CF2CCC4D814AB354416EA0FD073394@FIESEXC035.nsn-intra.net
Whole thread Raw
In response to Re: Synch Replication  (Fujii Masao <masao.fujii@gmail.com>)
List pgsql-hackers
hi,

[I am working in the same team as Niranjan]

Niranjan wrote:
> > 3) Do you have test programs that can used
> > for synchronous replication testing?
>
> No, I've not used the automated test program. Yeah, since
> it's very useful, I'll make it before long.
>
> > 4) I'am thinking of trying load/performance tests as well.
> > What do you feel? Will it be too early to do this test?
>
> Any kinds of testing welcome!

Actually, this is just to let you know that for _stability_ and
performance tests we use the "Network Database Benchmark" which
we open-sourced (GPLv2) in 2006. Just recently one of our
colleagues wrote a _small_ patch that makes it work out of the
box with _PostgreSQL_/UnixODBC. The patch is now also available.

The main project page(s): http://hoslab.cs.helsinki.fi/savane/projects/ndbbenchmark/
http://hoslab.cs.helsinki.fi/homepages/ndbbenchmark/

The patch:
http://hoslab.cs.helsinki.fi/savane/cookbook/?func=detailitem&item_id=14
1

The benchmark models a Telco home location register (HLR)
application with lots of short read/write transactions whose
ratio can be adjusted on the command line, e.g. to model read
or write heavy transaction loads. We'll re-use this benchmark
as we have lots of existing measurements for other databases.
Also we have a pretty good understanding of what to expect
performance-wise with the different transaction mixes. The
actual benchmark specification is available from here

The benchmark spec:
http://hoslab.cs.helsinki.fi/downloads/ndbbenchmark/Network_Database_Ben
chmark_Definition_2006-02-01.pdf

Thoralf


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [COMMITTERS] pgsql: Redefine _() to dgettext() instead of gettext() so that it uses
Next
From: David Fetter
Date:
Subject: Re: [GENERAL] Good Delimiter for copy command