From: | Enrico Sirola <enrico(dot)sirola(at)gmail(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: 8.3 write performance |
Date: | 2008-03-14 10:17:12 |
Message-ID: | 4FDAF452-E6CD-46CA-96DA-8674E496C5D4@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Jurgen Haan | 2008-03-14 10:20:52 | Re: ER diagram tool |
Previous Message | Justin | 2008-03-14 08:31:29 | Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 |