Re: Prepare enabled pgbench

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
Cc: curtis(at)galtair(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Prepare enabled pgbench
Date: 2002-11-13 01:59:45
Message-ID: 200211130159.gAD1xkQ09568@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tatsuo Ishii wrote:
> > Tatsuo, are you or anyone else working on adding PREPARE, EXECUTE support to
> > pgbench?
>
> As far as I know, no one is working on that.
>
> > If not, I can do it myself and if you are interested, I'll send you the
> > patch.
>
> Thanks. I can commit it for 7.4. BTW, it would be nice if we could
> have a switch to turn on/off PREPARE/EXECUTE in pgbench so that we
> could see how PRPARE/EXECUTE could improve the performance...

We could probably just run before-after patch tests to see the
performance change. I am afraid adding that switch into the code may
make it messy.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-11-13 02:10:13 Re: CREATE TABLE/AS does not allow WITH OIDS?
Previous Message Tatsuo Ishii 2002-11-13 01:50:51 Re: Prepare enabled pgbench