pgpool2.git / summary / log / commit / refs
commit cc33ffccf6630b7ec911aac8c4878918db5a35e8
Author: Tatsuo Ishii <ishii@sraoss.co.jp>
Date: Fri Aug 02 00:05:49 2019 +0000
Doc: mention the separate parser patch.
doc/src/sgml/release-4.1.sgml | 49 ++++++++++++++++++++++++++++++++++++++++++-
1 file changed, 48 insertions(+), 1 deletion(-)
diff --git a/doc/src/sgml/release-4.1.sgml b/doc/src/sgml/release-4.1.sgml
index 93ad514f3..00bf7dacd 100644
--- a/doc/src/sgml/release-4.1.sgml
+++ b/doc/src/sgml/release-4.1.sgml
@@ -50,7 +50,7 @@
<para>
Enhance performance in number of areas.
<itemizedlist>
- <listitem>
+ <listitem>
<para>
Shared relation cache allows to reuse relation cache
among sessions to reduce internal queries
@@ -58,6 +58,12 @@
catalogs.
</para>
</listitem>
+ <listitem>
+ <para>
+ Have separate SQL parser for DML statements to
+ eliminate unnecessary parsing effort.
+ </para>
+ </listitem>
<listitem>
<para>
Load balancing control for specific queries.
@@ -251,6 +257,47 @@
</para>
</listitem>
+ <listitem>
+ <!--
+ 2019-08-02 [310c5c4a]
+ -->
+ <para>
+ Performance enhancements for the large INSERT and UPDATE
+ statements. (Muhammd Usama)
+ </para>
+ <para>
+ <productname>Pgpool-II</productname> only needs very little
+ information, especially for the INSERT and UPDATE statements
+ to decide where it needs to send the query. For example: In
+ master-slave mode, for the INSERT
+ statements <productname>Pgpool-II</productname> only
+ requires the relation name referenced in the statement while
+ it doesn't care much about the column values and other
+ parameters. But since the parser we use
+ in <productname>Pgpool-II</productname> is taken
+ from <productname>PostgreSQL</productname> source which
+ parses the complete query including the value lists which
+ seems harmless for smaller statements but in case of INSERT
+ and UPDATE with lots of column values and large data in
+ value items, consumes significant time.
+ </para>
+ <para>
+ So the idea here is to short circuit the INSERT and UPDATE
+ statement parsing as soon as we have the required
+ information. For that purpose, the commit adds the second
+ minimal parser that gets invoked in master-slave mode and
+ tries to extract the performance for large INSERT and UPDATE
+ statements.
+ </para>
+ <para>
+ Apart from the second parser addition, changes aiming
+ towards the performance enhancements are also part of the
+ commit. See
+ the <ulink url="https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=310c5c4a289cbe6cee01abef7d2e7bc3550944fb">commit
+ log</ulink> for more details.
+ </para>
+ </listitem>
+
<listitem>
<!--
2019-07-24 [f694283c]
[parent: 310c5c4a289c]