| 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: | 2007-10-17 06:39:02 |
| Message-ID: | 20071017152035.86C8.ITAGAKI.TAKAHIRO@oss.ntt.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Here is a patch for testing query modes on pgbench. It is discussed on
http://archives.postgresql.org/pgsql-hackers/2007-10/msg00755.php
I think this is useful to measure performance of protocols and
prepared statements. I hope the extended protocol will be improved
as fast as the simple protocol. It is 10-20% slower now.
(for 8.4 item)
The querymode option is added:
-M querymode
Choose the query mode from the follows:
simple: using simple query protocol.
extended: using extended protocol.
prepared: using extended protocol with prepared statements.
default is simple.
Usage:
$ pgbench -M [simple|extended|prepared]
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
| Attachment | Content-Type | Size |
|---|---|---|
| pgbench_querymode.patch | application/octet-stream | 9.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kuriakose, Cinu Cheriyamoozhiyil | 2007-10-17 06:40:01 | CVS and Eclipse |
| Previous Message | Magnus Hagander | 2007-10-17 05:20:56 | Re: 8.2.3: Server crashes on Windows using Eclipse/Junit |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ITAGAKI Takahiro | 2007-10-17 08:10:07 | BUG #3681: fillers are NULL in pgbench |
| Previous Message | Chris Browne | 2007-10-16 20:24:30 | Re: [RFC] extended txid docs |