[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