Re: Avoiding bad prepared-statement plans. - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Avoiding bad prepared-statement plans.
Date
Msg-id 162867791002160631h7814785bo64d3e203fddb3ac1@mail.gmail.com
Whole thread Raw
In response to Re: Avoiding bad prepared-statement plans.  (Greg Stark <gsstark@mit.edu>)
List pgsql-hackers
>
> Well using parameters will always have a better chance of producing a
> better plan but that's not the only factor people consider important.
> For a lot of users *predictability* is more important than absolute
> performance. If my web server could run 10% faster that might be nice
> but if it's capable of keeping up at its current speed it's not
> terribly important. But if it means it crashes once a day because some
> particular combination of parameters causes a bad plan to be used for
> a specific user that's a bad trade-off.
>

+1

Pavel

> --
> greg
>


pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: Avoiding bad prepared-statement plans.
Next
From: Alvaro Herrera
Date:
Subject: Re: Explain buffers display units.