[pgpool-hackers: 2843] Re: [pgpool-committers: 4826] pgpool: Deal with DROP DATABASE command.

Tatsuo Ishii ishii at sraoss.co.jp
Wed Jun 27 18:03:27 JST 2018


I have tested this using pgbench -S and the result was disappointing.
I guess the bottle neck is, large data updating, which is necessary to
maintain query cache hash vs. table oid list. I will work on improving
this, but if I still get poor performance, maybe I should abandon
this.

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

> Deal with DROP DATABASE command.
> 
> Now query cache with memcached works with the command.
> 
> Branch
> ------
> query_cache
> 
> Details
> -------
> https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=f71a67fef4d0c8324a3560c798947fce470cdd36
> 
> Modified Files
> --------------
> src/include/query_cache/pool_memqcache.h |   2 -
> src/query_cache/pool_oid_map.c           | 128 ++++++++++++++++++++++++++-----
> 2 files changed, 107 insertions(+), 23 deletions(-)
> 


More information about the pgpool-hackers mailing list