Re: [PERFORM] Query much slower when run from postgres function

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: [PERFORM] Query much slower when run from postgres function
Дата
Msg-id 491f66a50903091256n7fe4a3f6i93267d0d53b983cb@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PERFORM] Query much slower when run from postgres function  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [PERFORM] Query much slower when run from postgres function
Re: [PERFORM] Query much slower when run from postgres function
Список pgsql-jdbc
Дерево обсуждения


On Mon, Mar 9, 2009 at 1:16 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Guillaume Smet <guillaume.smet@gmail.com> writes:
> Unnamed prepared statements are planned after binding the values,
> starting with 8.3, or more precisely starting with 8.3.2 as early 8.3
> versions were partially broken on this behalf.

No, 8.2 did it too (otherwise we wouldn't have considered 8.3.0 to be
broken...).  The thing I'm not too clear about is what "use of an
unnamed statement" translates to for a JDBC user.

Tom,

The driver will use unnamed statements for all statements until it sees the same statement N times where N is 5 I believe, after that it uses a named statement.

Dave

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Mario Splivalo
Дата:
Сообщение: Re: [PERFORM] Query much slower when run from postgres function
Следующее
От: James Mansion
Дата:
Сообщение: Re: [PERFORM] Query much slower when run from postgres function