[pgpool-hackers: 1303] Re: [pgpool -C option] need more description?

Tatsuo Ishii ishii at postgresql.org
Tue Jan 5 23:22:52 JST 2016


> Hi all,
> 
> I think below case is depended on the way of using
> but is it need to be added more detail at pgpool -C option?
> something like "But not clear related cache in memcached server."?
> 
> When memcached is using in "In Memory Cached" mode, pgpool 
> start with -C option does not clear related cache in cache 
> server.
> Obviously it lead to get the old query result by SELECT
> as below.

Sounds a fair complaint. Will fix.

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

> ===
> 
> testdb=# select * from testtbl;   -- create cache
>  id
> ----
>   1
> (1 row)
> 
> testdb=# \q
> ]$ pgpool stop
> ]$ pgpool -C -d -n > /var/log/pgpool/log 2>&1 & # start with -C option 
> ]$ psql -p 9999
> psql (9.4.4)
> Type "help" for help.
> 
> testdb=# insert into testtbl values(1);
> INSERT 0 1
> testdb=# select * from testtbl;  -- old query result from cache server
>  id
> ----
>   1
> (1 row)
> 
> ===
> 
> Best regards,
> ---
> Dang Minh Huong 
> NEC Solution Innovators, Ltd. 
> http://www.nec-solutioninnovators.co.jp/en/
> 
> _______________________________________________
> pgpool-hackers mailing list
> pgpool-hackers at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-hackers


More information about the pgpool-hackers mailing list