| From: | Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> |
|---|---|
| To: | Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com> |
| Cc: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Cached plans and statement generalization |
| Date: | 2017-09-11 09:24:45 |
| Message-ID: | b542f0ee-02be-01cc-d8ee-af1a5a1718c3@postgrespro.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 09.09.2017 06:35, Thomas Munro wrote:
> On Fri, May 26, 2017 at 3:54 AM, Konstantin Knizhnik
> <k(dot)knizhnik(at)postgrespro(dot)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
| Attachment | Content-Type | Size |
|---|---|---|
| autoprepare-3.patch | text/x-patch | 42.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ildus Kurbangaliev | 2017-09-11 09:33:32 | Re: Remove 1MB size limit in tsvector |
| Previous Message | Aleksander Alekseev | 2017-09-11 09:24:16 | Re: Red-black trees: why would anyone want preorder or postorder traversal? |