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

[Avi Raboah]

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?

Thanks,

Avi.

On Tue, 3 May 2022 at 15:31 Tatsuo Ishii <ishii at sraoss.co.jp> wrote:

> Hi,
>
> > 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
> Japanese:http://www.sraoss.co.jp
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20220503/0f3ec4a7/attachment.htm>