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

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 (view raw or flat)
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

pgsql-jdbc by date

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

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