[pgpool-general: 8120] Re: Sync tables oid between multiple piggy pools
avi.raboah at gmail.com
Tue May 3 21:38:39 JST 2022
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
On Tue, 3 May 2022 at 15:31 Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
> > In case I am using multiple piggy pools with central memcached. How piggy
> > pools share the table oids which stored on specific piggy pool?
> Assuming all the pgpool processes are forked off by the same pgpool
> parent process, they share the table oids under
> log/pgpool/oiddir/<database oid>/<table oid>.
> See the source code comment for pool_get_database_oid().
> Best reagards,
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pgpool-general