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: 2008-03-18 07:09:20
Message-ID: 20080318155525.6B6B.52131E4D@oss.ntt.co.jp (view raw or flat)
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: pgbench_querymode.patch
Description: application/octet-stream (12.0 KB)

Responses

pgsql-patches by date

Next:From: NikhilSDate: 2008-03-18 07:48:19
Subject: Re: UPDATE using sub selects
Previous:From: KaiGai KoheiDate: 2008-03-18 03:16:27
Subject: Re: [0/4] Proposal of SE-PostgreSQL patches

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