Re: 8.3 write performance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux