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

Tatsuo Ishii ishii at postgresql.org
Thu Jun 25 09:32:34 JST 2015

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:

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

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

More information about the pgpool-hackers mailing list