From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | "Reuven M(dot) Lerner" <reuven(at)lerner(dot)co(dot)il> |
Cc: | List <pgsql-jdbc(at)postgresql(dot)org>, kim+pg(at)alleroedderne(dot)adsl(dot)dk |
Subject: | Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows) |
Date: | 2013-06-25 12:58:46 |
Message-ID: | CADK3HH+74PdAxFt3GkpRUeowiAGQ6DJ0iHYq=fuP=twKaMpC=g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Reuven M. Lerner | 2013-06-25 13:12:32 | Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows) |
Previous Message | Reuven M. Lerner | 2013-06-25 12:55:50 | Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows) |