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 Reuven M. Lerner
Subject Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows)
Date
Msg-id 51C99356.8000004@lerner.co.il
Whole thread Raw
In response to Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows)  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows)  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
Tree view 
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: Dave Cramer
Date:
Subject: Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows)
Next
From: Dave Cramer
Date:
Subject: Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows)