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

Re: Patch for testing query modes on pgbench

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Patch for testing query modes on pgbench
Date: 2007-11-05 16:11:04
Message-ID: 200711051611.lA5GB4W18923@momjian.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
This has been saved for the 8.4 release:

	http://momjian.postgresql.org/cgi-bin/pgpatches_hold

---------------------------------------------------------------------------


ITAGAKI Takahiro wrote:
> 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, skipping... ]

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
> 
>                http://archives.postgresql.org

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://postgres.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2007-11-05 16:12:34
Subject: Re: Slow regression tests on windows
Previous:From: Tom LaneDate: 2007-11-05 16:10:50
Subject: Re: pgsql: Add a note about another issue that needs to be considered before

pgsql-patches by date

Next:From: Bruce MomjianDate: 2007-11-05 16:33:42
Subject: Re: Configurable Penalty Costs for Levenshtein
Previous:From: Bruce MomjianDate: 2007-11-05 15:23:16
Subject: Re: [RFC] extended txid docs

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