Postgres Pro
Downloads
Home   >   mailing lists

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 CAFj8pRB5+R0HHaBUPHA7aiLYzitoRJYYC7NFFHWKM=JzoT0pyw@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>)
Responses 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
Tree view


2016-01-12 16:52 GMT+01:00 Vladimir Sitnikov <sitnikov.vladimir@gmail.com>:
> I don't know if there is a good solution except disabling server prepared statements.

Why doesn't backend reuse already existing good plan?

probably good plan is more expensive than wrong plan :(

this logic is driven by plan cost, not by plan execution time.

 
The plan does account for the skew.

Can backend take selectivities from the original bind values?

Vladimir


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

pgsql-hackers by date:

Previous
From: Vladimir Sitnikov
Date:
Subject: Re: Fwd: [JDBC] Re: 9.4-1207 behaves differently with server side prepared statements compared to 9.2-1102
Next
From: Vladimir Sitnikov
Date:
Subject: Re: Fwd: [JDBC] Re: 9.4-1207 behaves differently with server side prepared statements compared to 9.2-1102