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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-jdbc by date

  From Date Subject
Next Message Daniel Migowski 2009-05-07 06:56:29 Re: Thread hangs in VisibleBufferedInputStream.readMore
Previous Message Simon Riggs 2009-05-06 21:59:54 Re: Very strange performance decrease when reusing a PreparedStatement