[pgpool-general: 3648] Re: Error in pgpool memory cache invalidation.
Dhananjay Balan
dhananjay at plivo.com
Wed Apr 22 17:26:16 JST 2015
Looks like only part of this email ended up in the mailing list , not
sure how. Resending again - hope it works this time.
pgpool doesn't seem to be invalidating caches properly. See the
example test case below
psql -U ruser -d mydb -h 127.0.0.1 -p 9999
Password for user ruser:
psql (9.4.1)
Type "help" for help.
mydb=> select comments from users where id=1;
comments
----------
boooo
(1 row)
# comes from cache
mydb=> select comments from users where id=1;
comments
----------
boooo
(1 row)
# works
mydb=> update users set comments='hello' where id=1;
UPDATE 1
mydb=> select comments from users where id=1;
comments
----------
hello
(1 row)
# stale
mydb=> update users set comments='hello world' where id=1;
UPDATE 1
mydb=> select comments from users where id=1;
comments
----------
hello
(1 row)
# also stale
mydb=> update users set comments='booo' where id=1;
UPDATE 1
mydb=> select comments from users where id=1;
comments
----------
hello
(1 row)
More information about the pgpool-general
mailing list