Postgres Pro
Downloads
Home   >   mailing lists

Re: Very strange performance decrease when reusing a PreparedStatement - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Very strange performance decrease when reusing a PreparedStatement
Date
Msg-id 491f66a50905010840m7f4745e5xd9a588a198a63f03@mail.gmail.com
Whole thread Raw
In response to Re: Very strange performance decrease when reusing a PreparedStatement  (Frédérik Bilhaut <frederik.bilhaut@noopsis.fr>)
List pgsql-jdbc
Tree view


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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc

pgsql-jdbc by date:

Previous
From: Frédérik Bilhaut
Date:
Subject: Re: Very strange performance decrease when reusing a PreparedStatement
Next
From: Adam B
Date:
Subject: A basic Statement.getGeneratedKeys() implementation (patch attached)