Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows)

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows)
Дата
Msg-id CADK3HH+74PdAxFt3GkpRUeowiAGQ6DJ0iHYq=fuP=twKaMpC=g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows)  ("Reuven M. Lerner" <reuven@lerner.co.il>)
Ответы Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows)  ("Reuven M. Lerner" <reuven@lerner.co.il>)
Список pgsql-jdbc
Дерево обсуждения
Reuven,

Sorry, my mistake. >= 9.2

And no that should not account for the differences

Any chance I can login to the box ? Failing that you will need to try to get the query plan

Bound parameters can be replicated using prepare and execute


prepare the query then run 

explain analyze on the execute to see the differences.



Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca


On Tue, Jun 25, 2013 at 8:55 AM, Reuven M. Lerner <reuven@lerner.co.il> wrote:
Hi, Dave. You wrote:

Postgresql version < 9.2 suffers from a problem with bound parameters
where the planner does not choose a good plan with bound parameters. If
I were a betting man I would bet that your linux box is not running
version > 9.2

select version() will confirm

We're actually running 9.2.  But your note only talked about < 9.2 and > 9.2, so I'm not sure where that leaves us...

Should we try the 9.3 beta?

Also, would that account for the differences between Windows and Linux?


Reuven

--
Reuven M. Lerner -- Web development, consulting, and training
Mobile: +972-54-496-8405 * US phone: 847-230-9795
http://lerner.co.il * Skype/AIM: reuvenlerner

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

Предыдущее
От: "Reuven M. Lerner"
Дата:
Сообщение: Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows)
Следующее
От: "Reuven M. Lerner"
Дата:
Сообщение: Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows)