[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