Re: Unfortunate Nested Loop + Missing Autovacuum

2025-02-23 Thread Jeff Janes
On Sun, Feb 23, 2025 at 5:49 PM Lincoln Swaine-Moore wrote: > Thanks for the reply! I tried the analysis on our much shorter staging > table and it did change the plan. I haven’t tried it on the production ones > because my understanding is that the autovacuum process is gentler with > resource c

Re: Unfortunate Nested Loop + Missing Autovacuum

2025-02-23 Thread Lincoln Swaine-Moore
Thanks for the reply! I tried the analysis on our much shorter staging table and it did change the plan. I haven’t tried it on the production ones because my understanding is that the autovacuum process is gentler with resource consumption and I didn’t want to gum things up in the meantime. But tha