Re: Jdbc/postgres performance

On 10/18/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Merlin Moncure" <mmoncure(at)gmail(dot)com> writes:
> > this is not really a jdbc issue, just a practical problem with
> > prepared statements...
>
> Specifically, that the OP is running a 7.4 backend, which was our
> first venture into prepared parameterized statements. PG 8.1 will
> do better, 8.2 should do better yet.

I haven't looked at 8.2 because I no longer work at my previous
position, but I was significantly affected by this problem through the
8.1 release. The speed advantages of preparing certain types queries
are dramatic and there are some decent use cases for pramaterizing
limit and other input parameters that are difficult to guess.

merlin