Skip site navigation (1) Skip section navigation (2)

Patch for testing query modes on pgbench

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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: pgbench_querymode.patch
Description: application/octet-stream (9.5 KB)

In response to

Responses

pgsql-hackers by date

Next:From: Kuriakose, Cinu CheriyamoozhiyilDate: 2007-10-17 06:40:01
Subject: CVS and Eclipse
Previous:From: Magnus HaganderDate: 2007-10-17 05:20:56
Subject: Re: 8.2.3: Server crashes on Windows using Eclipse/Junit

pgsql-patches by date

Next:From: ITAGAKI TakahiroDate: 2007-10-17 08:10:07
Subject: BUG #3681: fillers are NULL in pgbench
Previous:From: Chris BrowneDate: 2007-10-16 20:24:30
Subject: Re: [RFC] extended txid docs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group