[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