| 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: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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 |
| 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 |