| 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
| 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 |