From: | "Merlin Moncure" <mmoncure(at)gmail(dot)com> |
---|---|
To: | "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: HOT pgbench results |
Date: | 2007-08-07 19:33:11 |
Message-ID: | b42b73150708071233s64be75d5x85ec2c5d655234e0@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 8/7/07, Heikki Linnakangas <heikki(at)enterprisedb(dot)com> wrote:
> I ran some CPU intensive pgbench tests on HOT. Results are not
> surprising, HOT makes practically no difference on the total transaction
> rate, but reduces the need to vacuum:
>
> unpatched HOT
> tps 3680 3790
> WAL written(MB) 5386 4804
> checkpoints 10 9
> autovacuums 116 43
> autoanalyzes 139 60
Here are some more results...all stock except for partial writes, 24
segments (fsync on). hardware is four 15k sas in a raid 10. I am
seeing very good results in other real wold scenarios outside of
pgbench....anyone is interested drop me a line. Note I cut the
transaction runs down to 100k from 1M.
*** HOT ***
[postgres(at)efsd-main root]$ time pgbench -c 5 -t 100000
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 5
number of transactions per client: 100000
number of transactions actually processed: 500000/500000
tps = 1156.605130 (including connections establishing)
tps = 1156.637464 (excluding connections establishing)
real 7m12.311s
user 0m26.784s
sys 0m25.429s
*** cvs, HOT ***
[postgres(at)efsd-main pgsql]$ time pgbench -c 5 -t 100000
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 5
number of transactions per client: 100000
number of transactions actually processed: 500000/500000
tps = 630.510918 (including connections establishing)
tps = 630.520485 (excluding connections establishing)
real 13m13.019s
user 0m27.278s
sys 0m26.092s
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2007-08-07 19:35:23 | Re: HOT patch, missing things |
Previous Message | Gregory Stark | 2007-08-07 19:27:36 | Re: HOT pgbench results |