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

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

http://www.postgresql.org/docs/current/static/sql-prepare.html

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(at)lerner(dot)co(dot)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
>