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)
|
| Список | 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.
On Tue, Jun 25, 2013 at 8:55 AM, Reuven M. Lerner <reuven@lerner.co.il> wrote:
Hi, Dave. You wrote: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...
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
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 по дате отправления: