Postgres Pro
Downloads
Home   >   mailing lists

Re: Slowness of extended protocol - Mailing list pgsql-hackers

From Vladimir Sitnikov
Subject Re: Slowness of extended protocol
Date
Msg-id CAB=Je-EkcvERygZJNDEFRJRs_dixzfLFZvX7j1Xy+a+6Z9982A@mail.gmail.com
Whole thread Raw
In response to Re: Slowness of extended protocol  (Vladimir Sitnikov <sitnikov.vladimir@gmail.com>)
Responses Re: Slowness of extended protocol  (Shay Rojansky <roji@roji.org>)
Re: Slowness of extended protocol  (Tatsuo Ishii <ishii@postgresql.org>)
List pgsql-hackers
Tree view
>It it a bug? It think exec_parse_message should set is_oneshot=true for parse message with empty statement names.

I've tried "build from git as of 74d8c95b7456faefdd4244acf854361711fb42ce", and it produced PostgreSQL 9.6beta3 on x86_64-apple-darwin15.5.0, compiled by Apple LLVM version 7.0.0 (clang-700.1.76), 64-bit

The attached patch passes `make check` and it gains 31221 -> 33547 improvement for "extended pgbench of SELECT 1".

The same version gains 35682 in "simple" mode, and "prepared" mode achieves 46367 (just in case).
Attachment

pgsql-hackers by date:

Previous
From: Etsuro Fujita
Date:
Subject: Re: Oddity in EXPLAIN for foreign/custom join pushdown plans
Next
From: Etsuro Fujita
Date:
Subject: Confusing docs about GetForeignUpperPaths in fdwhandler.sgml