From: | ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> |
---|---|
To: | pgsql-patches(at)postgresql(dot)org |
Subject: | Patch for testing query modes on pgbench |
Date: | 2008-03-18 07:09:20 |
Message-ID: | 20080318155525.6B6B.52131E4D@oss.ntt.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
Here is a updated patch to add query modes into pgbench in order to
measure performance of simple protocol, extended protocol and
prepared statements with it.
[PATCHES] Patch for testing query modes on pgbench
http://momjian.us/mhonarc/patches/msg00335.html
A new runtime option (-M) is added:
-M querymode
Choose the query mode from the follows. default is simple.
- simple: using simple query protocol.
- extended: using extended protocol.
- prepared: using extended protocol with prepared statements.
----
Extended protocol is slower than simple protocol. I think it is a problem
because we have to use the protocol (and cannot use prepared statements)
in some situations, such as connectiong with JDBC to partitioned tables.
$ pgbench -S -n -c5 -t10000 -M simple
tps = 3567.351598 (excluding connections establishing)
$ pgbench -S -n -c5 -t10000 -M extended
tps = 2877.697842 (excluding connections establishing)
$ pgbench -S -n -c5 -t10000 -M prepared
tps = 4532.680627 (excluding connections establishing)
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
Attachment | Content-Type | Size |
---|---|---|
pgbench_querymode.patch | application/octet-stream | 12.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | NikhilS | 2008-03-18 07:48:19 | Re: UPDATE using sub selects |
Previous Message | KaiGai Kohei | 2008-03-18 03:16:27 | Re: [0/4] Proposal of SE-PostgreSQL patches |