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

Re: Very strange performance decrease when reusing a PreparedStatement

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>
Cc: Roland Roberts <roland(at)astrofoto(dot)org>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Very strange performance decrease when reusing a PreparedStatement
Date: 2009-05-06 22:39:08
Message-ID: 29597.1241649548@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-jdbc
Simon Riggs <simon(at)2ndQuadrant(dot)com> writes:
> We talked a few years back about an "Option node" that would select
> sub-plans at runtime based upon the actual values of the bind variable.
> Nobody's got around to doing anything with that yet.

There is an AlternativeSubPlan mechanism in 8.4, though we're not doing
very much with it yet.

			regards, tom lane

In response to

Responses

pgsql-jdbc by date

Next:From: Daniel MigowskiDate: 2009-05-07 06:56:29
Subject: Re: Thread hangs in VisibleBufferedInputStream.readMore
Previous:From: Simon RiggsDate: 2009-05-06 21:59:54
Subject: Re: Very strange performance decrease when reusing aPreparedStatement

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