Re: Proposal: Recent mutated table tracking in memory

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: nadav(at)tailorbrands(dot)com
Cc: pgpool-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Proposal: Recent mutated table tracking in memory
Date: 2026-01-30 08:09:50
Message-ID: 20260130.170950.551399957723794225.ishii@postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgpool-hackers

> yes indeed, please find attached.

Thanks. Here some comments on the patch:

- It seems you use a table name (and schema) for a key to identify the
TableMutationEntry and other objects. I think you should use table
oids for the key because the same table name could exists in
different schema. Moreover, if the database is different from the
database when the map entry was created, a map look up could return
incorrect result. In summary the key should be table oid and
database oid (which is already done by query cache subsystem).

- In the patch spin lock primitives are introduced. Why can't we use
semaphore instead? A spin lock uses busy loop, which could increase
the system load if the duration of locking becomes longer.

- What would happen if the leader watchdog fails and other watchdog
node take the place of the leader role?

- pool_memory_map_get_ttl() and pool_memory_map_get_stats() are
defined but are not used anywhere. Why do you have them?

- I think "memory_map" is a too generic name. Can we use more specific
name for the feature?

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

In response to

Responses

Browse pgpool-hackers by date

  From Date Subject
Next Message Nadav Shatz 2026-01-31 17:11:14 Re: Proposal: Recent mutated table tracking in memory
Previous Message Nadav Shatz 2026-01-29 08:54:48 Re: Proposal: Recent mutated table tracking in memory