From: Enrico Sirola <enrico.sirola@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: 8.3 write performance
Date: Fri, 14 Mar 2008 11:17:12 +0100
Message-ID: <4FDAF452-E6CD-46CA-96DA-8674E496C5D4@gmail.com> (raw)
In-Reply-To: <2226A814-87D8-4531-AC26-D1E7B44227C0@gmail.com>
References: <2226A814-87D8-4531-AC26-D1E7B44227C0@gmail.com>
Hi,
I follow up myself: I was using pgbench with the wrong scale size.
With the configuration I posted before and scale=100 I Get the
following:
sudo -u postgres pgbench -c 10 -t 10000 -s 100
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 100
number of clients: 10
number of transactions per client: 10000
number of transactions actually processed: 100000/100000
tps = 4399.753895 (including connections establishing)
tps = 4405.228901 (excluding connections establishing)
sudo -u postgres pgbench -c 50 -t 10000 -s 100
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 100
number of clients: 50
number of transactions per client: 10000
number of transactions actually processed: 500000/500000
tps = 3208.532479 (including connections establishing)
tps = 3211.816174 (excluding connections establishing)
which I think is in line with the expectations.
Thanks,
e.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: enrico.sirola@gmail.com
Subject: Re: 8.3 write performance
In-Reply-To: <4FDAF452-E6CD-46CA-96DA-8674E496C5D4@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox