Re: Eliminating SPI / SQL from some RI triggers - take 3

2025-04-03 Thread Amit Langote
On Fri, Dec 20, 2024 at 1:23 PM Amit Langote wrote: > We discussed $subject at [1] and [2] and I'd like to continue that > work with the hope to commit some part of it for v18. I did not get a chance to do any further work on this in this cycle, but plan to start working on it after beta release,

Eliminating SPI / SQL from some RI triggers - take 3

2024-12-19 Thread Amit Langote
Hi, We discussed $subject at [1] and [2] and I'd like to continue that work with the hope to commit some part of it for v18. In short, performing the RI checks for inserts and updates of a referencing table as direct scans of the PK index results in up to 40% improvement in their performance, esp