[pgpool-general: 8121] Re: Sync tables oid between multiple piggy pools

[Tatsuo Ishii]

> I am talking about two different pgpools instances.
> 
> Let say the following :
> Pgpool A - select from t1 … (saved in cache and the table oid stored in
> pgpool A file system)
> 
> Pgpool B - update t1 … ( invalidation should occure but the oid for the
> table t1 stored in pgpool A)
> 
> Do pgpool support a mechanism to share this information between pgpool
> instances?

No.  Long time ago I tried to manage the table oid data in memcahced
so that different pgpool instances can share the table oid data. The
attempt miserably failed because memcached feels free to destroy the
table oid data.

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