Re: Fwd: [JDBC] Re: 9.4-1207 behaves differently with server side prepared statements compared to 9.2-1102 - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Fwd: [JDBC] Re: 9.4-1207 behaves differently with server side prepared statements compared to 9.2-1102
Date
Msg-id CAFj8pRC6Vj351-jmE2sg2dcUWGDLjCDTiofZ-v4aAdMEkE8TFQ@mail.gmail.com
Whole thread Raw
In response to Re: Fwd: [JDBC] Re: 9.4-1207 behaves differently with server side prepared statements compared to 9.2-1102  (Vladimir Sitnikov <sitnikov.vladimir@gmail.com>)
List pgsql-hackers


2016-01-13 17:12 GMT+01:00 Vladimir Sitnikov <sitnikov.vladimir@gmail.com>:
>If plan is ok for one value parameters, then can be pretty bad for following parameters.

Happy statements are all alike; every unhappy statement is unhappy in
its own way (see [1]).
If user is sending different kinds of parameters, he is shooting in the foot.

>Albe's proposal can be good enough for 2/3 cases and it doesn't block any other enhancing

Albe's proposal effectively disables plan cache, thus it blocks enhancing.
If a user goes "replan every time" route, there is no way you
introduce plan caching there.

I am sorry, I disagree. Albe's proposal should be compatible with current state, so your argument is too strong. Default is same.

Pavel
 

[1]: https://en.wikipedia.org/wiki/Anna_Karenina_principle

Vladimir

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump and premature optimizations for objects not to be dumped
Next
From: Tom Lane
Date:
Subject: Python 3.x versus PG 9.1 branch