Re: Prepared statments: partial indexes are avoided! - Mailing list pgsql-admin

From bricklen
Subject Re: Prepared statments: partial indexes are avoided!
Date
Msg-id BANLkTinZ8e4b9=nZTGP=Ztuw66AUCra6uA@mail.gmail.com
Whole thread Raw
In response to Re: Prepared statments: partial indexes are avoided!  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-admin
On Mon, Jun 20, 2011 at 7:06 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> Unfortunately, prepared statements do act in the way you have seen.
>
> I have a patch into 9.2 under discussion to improve upon this
> situation, but don't hold your breath for that.
>
> --
>  Simon Riggs                   http://www.2ndQuadrant.com/
>  PostgreSQL Development, 24x7 Support, Training & Services
>

I haven't used Oracle in years, but I seem to recall that they had
"bind variable peeking" to work around this type of problem. That
would be interesting to have in PG.

pgsql-admin by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: dump from 9.0 to 8.3
Next
From: Achilleas Mantzios
Date:
Subject: Re: dump from 9.0 to 8.3