Re: Very strange performance decrease when reusing a PreparedStatement

Поиск
Список
Период
Сортировка
Искать
От
Dave Cramer
Тема
Re: Very strange performance decrease when reusing a PreparedStatement
Дата
в 13:13:43
Msg-id
491f66a50905010840m7f4745e5xd9a588a198a63f03@mail.gmail.com
Ответ на
Список
Дерево обсуждения
Very strange performance decrease when reusing a PreparedStatement Frédérik Bilhaut <frederik.bilhaut@noopsis.fr>
Re: Very strange performance decrease when reusing a PreparedStatement Oliver Jowett <oliver@opencloud.com>
Re: Very strange performance decrease when reusing a PreparedStatement Frédérik Bilhaut <frederik.bilhaut@noopsis.fr>
Re: Very strange performance decrease when reusing a PreparedStatement Dave Cramer <pg@fastcrypt.com>
Re: Very strange performance decrease when reusing a PreparedStatement Oliver Jowett <oliver@opencloud.com>
Re: Very strange performance decrease when reusing a PreparedStatement Péter Kovács <maxottovonstirlitz@gmail.com>
Re: Very strange performance decrease when reusing a PreparedStatement Dave Cramer <pg@fastcrypt.com>
Re: Very strange performance decrease when reusing a PreparedStatement John Lister <john.lister-ps@kickstone.com>
Re: Very strange performance decrease when reusing a PreparedStatement Tom Lane <tgl@sss.pgh.pa.us>
Re: Very strange performance decrease when reusing a PreparedStatement John Lister <john.lister-ps@kickstone.com>
Re: Very strange performance decrease when reusing a PreparedStatement Oliver Jowett <oliver@opencloud.com>
Re: Very strange performance decrease when reusing a PreparedStatement Oliver Jowett <oliver@opencloud.com>
Re: Very strange performance decrease when reusing a PreparedStatement Péter Kovács <maxottovonstirlitz@gmail.com>
Re: Very strange performance decrease when reusing a PreparedStatement Roland Roberts <roland@astrofoto.org>
Re: Very strange performance decrease when reusing a PreparedStatement Simon Riggs <simon@2ndQuadrant.com>
Re: Very strange performance decrease when reusing a PreparedStatement Tom Lane <tgl@sss.pgh.pa.us>
Re: Very strange performance decrease when reusing a PreparedStatement Simon Riggs <simon@2ndQuadrant.com>
Re: Very strange performance decrease when reusing a PreparedStatement Péter Kovács <maxottovonstirlitz@gmail.com>
Re: Very strange performance decrease when reusing a PreparedStatement John Lister <john.lister-ps@kickstone.com>
Re: Very strange performance decrease when reusing a PreparedStatement Roland Roberts <roland@astrofoto.org>
Re: Very strange performance decrease when reusing a PreparedStatement Thomas Kellerer <spam_eater@gmx.net>
Re: Very strange performance decrease when reusing a PreparedStatement Oliver Jowett <oliver@opencloud.com>
Re: Very strange performance decrease when reusing a PreparedStatement Oliver Jowett <oliver@opencloud.com>
Re: Very strange performance decrease when reusing a PreparedStatement Péter Kovács <maxottovonstirlitz@gmail.com>
Re: Very strange performance decrease when reusing a PreparedStatement Mikko Tiihonen <mikko.tiihonen@nitorcreations.com>


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 по дате отправления
От: Frédérik Bilhaut
Дата:
От: Adam B
Дата:
FAQ