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

From: "Reuven M(dot) Lerner" <reuven(at)lerner(dot)co(dot)il>
To: Dave Cramer <pg(at)fastcrypt(dot)com>
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:55:50
Message-ID: 51C99356.8000004@lerner.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2013-06-25 12:58:46 Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows)
Previous Message Dave Cramer 2013-06-25 12:53:05 Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows)