[pgpool-hackers: 953] Re: [pgpool-committers: 2571] pgpool: Fix the case when user table includes spaces.

[Tatsuo Ishii]

Hi pgpool hackers,

I fixed a really nasty bug which issues unnecessary query to
PostgreSQL to check if insert lock is needed in none replication mode.
This is applied to simple protocol case.

I found this while taking care of this:
http://www.pgpool.net/mantisbt/view.php?id=136 

Good new is, the fix should slightly enhance performance of extended
protocol case in streaming replication mode because it eliminates
sending a query against PostgreSQL system catalog. I have not done a
benchmark test though.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

From: Tatsuo Ishii <ishii at postgresql.org>
Subject: [pgpool-committers: 2583] pgpool: Do not send a query for checking insert lock in non replication
Date: Wed, 24 Jun 2015 23:33:32 +0000
Message-ID: <E1Z7uAe-0006sV-8Q at gothos.postgresql.org>

> Do not send a query for checking insert lock in non replication mode with extended query
> 
> This unnecessary code was there since day 0.
> 
> Branch
> ------
> master
> 
> Details
> -------
> http://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=363a296c15a1488c22c6a5bb8662f415668b0ea6
> 
> Modified Files
> --------------
> src/protocol/pool_proto_modules.c |    6 +++++-
> 1 file changed, 5 insertions(+), 1 deletion(-)
> 
> _______________________________________________
> pgpool-committers mailing list
> pgpool-committers at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-committers