[pgpool-hackers: 1301] [pgpool -C option] need more description?
Huong Dangminh
huo-dangminh at ys.jp.nec.com
Tue Jan 5 12:23:36 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.
===
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/
More information about the pgpool-hackers
mailing list