Re: Very strange performance decrease when reusing a PreparedStatement

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Frédérik Bilhaut <frederik(dot)bilhaut(at)noopsis(dot)fr>
Cc: Oliver Jowett <oliver(at)opencloud(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Very strange performance decrease when reusing a PreparedStatement
Date: 2009-05-01 15:40:41
Message-ID: 491f66a50905010840m7f4745e5xd9a588a198a63f03@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Make sure you use a prepared statement in psql to do the explain analyze.

explain analyze select ....

is not the same as

prepare foo as select ...
explain analyze execute ...

Dave

>
>
>
>
>
>
>
>
>
>
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Adam B 2009-05-01 20:40:13 A basic Statement.getGeneratedKeys() implementation (patch attached)
Previous Message John Lister 2009-05-01 09:56:16 Unit test patches