Re: Cached plans and statement generalization

From: Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Cached plans and statement generalization
Date: 2017-09-12 17:11:27
Message-ID: e6ced412-75ee-b4a8-d61d-68fed2cfe8cc@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-hackers

On 11.09.2017 12:24, Konstantin Knizhnik wrote:
> 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
>
>

One more patch passing all regression tests with autoprepare_threshold=1.
I still do not think that it should be switch on by default...

--
Konstantin Knizhnik
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

Attachment Content-Type Size
autoprepare-4.patch text/x-patch 71.6 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2017-09-12 17:13:22 Re: pgbench regression test failure
Previous Message Fabien COELHO 2017-09-12 17:08:31 Re: pgbench regression test failure