Fluctuating performance of updates on small table with trigger

2022-06-29 Thread Mikkel Lauritsen
Hi all, I have a performance issue that I would really appreciate if somebody could help me better understand and investigate. I experience fluctuating performance of combined updates and inserts, seemingly following a pattern which isn't immediately obvious. In short I'm running PostgreSQL

Re: Fluctuating performance of updates on small table with trigger

2022-06-29 Thread Justin Pryzby
On Wed, Jun 29, 2022 at 09:31:58PM +0200, Mikkel Lauritsen wrote: > In short I'm running PostgreSQL 14.1 on Linux on a small test machine with should try to upgrade to 14.4, for $reasons > Is there any feasible way to find out what it is that causes Postgres to > start doing slow updates? My gues