> 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.
In response to
pgsql-hackers by date
|Next:||From: Alvaro Herrera||Date: 2010-02-16 14:36:32|
|Subject: Re: Explain buffers display units.|
|Previous:||From: Greg Stark||Date: 2010-02-16 14:28:57|
|Subject: Re: Avoiding bad prepared-statement plans.|