On Sun, 2021-07-18 at 09:36 +0200, Tobias Gierke wrote:
> Thank you for the detailed explanation ! Just one more question: I've
> did an experiment and reduced the fillfactor on the table updated by the
> trigger to 50%, hoping the HOT feature would kick in and each
> subsequent INSERT would cl
Thank you for the detailed explanation ! Just one more question: I've
did an experiment and reduced the fillfactor on the table updated by the
trigger to 50%, hoping the HOT feature would kick in and each
subsequent INSERT would clean up the "HOT chain" of the previous INSERT
... but execution
Great idea ! This brought the time per INSERT into the parent table down
to a consistent ~0.065ms again (compared to 0.05ms when completely
removing the trigger, so penalty for the trigger is roughly ~20%).
On Sat, 17 Jul 2021 at 16:40, Justin Pryzby wrote:
You could run a single UPDATE rath
