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

[Tatsuo Ishii]

I appeared that the implementation of -c or --clear-cache is quite
confusing. It does exactly the same thing as -C or --clear-oidmaps. So
there's no point to have both of options at all.  Moreover -c or
--clear-cache is not shown when pgpool --help is requested. Apparently
-c or --clear-cache is useless, and I doubt if we need to have this in
3.5.

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

>> 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
> _______________________________________________
> pgpool-hackers mailing list
> pgpool-hackers at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-hackers