Re: Prepare enabled pgbench - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Prepare enabled pgbench
Date
Msg-id 200211130159.gAD1xkQ09568@candle.pha.pa.us
Whole thread Raw
In response to Re: Prepare enabled pgbench  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: Prepare enabled pgbench  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List 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@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Prepare enabled pgbench
Next
From: Bruce Momjian
Date:
Subject: Re: CREATE TABLE/AS does not allow WITH OIDS?