Re: 8.3 write performance

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.

In response to

Browse pgsql-performance by date

  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