Postgres Pro
Downloads
Home   >   mailing lists

Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows) - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows)
Date
Msg-id CADK3HH+74PdAxFt3GkpRUeowiAGQ6DJ0iHYq=fuP=twKaMpC=g@mail.gmail.com
Whole thread Raw
In response to Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows)  ("Reuven M. Lerner" <reuven@lerner.co.il>)
Responses Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows)  ("Reuven M. Lerner" <reuven@lerner.co.il>)
List pgsql-jdbc
Tree view
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 by date:

Previous
From: "Reuven M. Lerner"
Date:
Subject: Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows)
Next
From: "Reuven M. Lerner"
Date:
Subject: Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows)