On 09.09.2017 06:35, Thomas Munro wrote:
On Fri, May 26, 2017 at 3:54 AM, Konstantin Knizhnik
<k.knizhnik@postgrespro.ru> wrote:
Attached please find rebased version of the autoprepare patch based on Tom's
proposal (perform analyze for tree with constant literals and then replace
them with parameters).
Also I submitted this patch for the Autum commitfest.
The patch didn't survive the Summer bitrotfest. Could you please rebase it?
Attached please find rebased version of the patch.
There are the updated performance results (pgbench -s 100 -c 1):
protocol (-M)
| read-write
| read-only (-S)
|
simple
| 3327
| 19325
|
extended
| 2256
| 16908
|
prepared
| 6145
| 39326
|
simple+autoprepare
| 4950
| 34841
|
--
Konstantin Knizhnik
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company