Re: Sudden increase in n_dead_tup with no corresponding insert/update/delete

2025-06-04 Thread Ron Johnson
Note also that 15.6 is about 18 months old. Upgrading really does only take a few minutes, if you download the binaries before installation. On Wed, Jun 4, 2025 at 2:37 PM Matthew Tice wrote: > > > On Jun 3, 2025, at 6:23 PM, David Rowley wrote: > > > > On Wed, 4 Jun 2025 at 07:22, Matthew Tic

Re: Sudden increase in n_dead_tup with no corresponding insert/update/delete

2025-06-04 Thread Matthew Tice
> On Jun 3, 2025, at 6:23 PM, David Rowley wrote: > > On Wed, 4 Jun 2025 at 07:22, Matthew Tice wrote: >> Tue 03 Jun 2025 07:13:11 PM UTC (every 1s) >> n_dead_tup | 5038 >> autoanalyze_count | 3078 > >> Tue 03 Jun 2025 07:13:12 PM UTC (every 1s) >> n_dead_tup | 1290579 >>

Re: Sudden increase in n_dead_tup with no corresponding insert/update/delete

2025-06-03 Thread David Rowley
On Wed, 4 Jun 2025 at 07:22, Matthew Tice wrote: > Tue 03 Jun 2025 07:13:11 PM UTC (every 1s) > n_dead_tup | 5038 > autoanalyze_count | 3078 > Tue 03 Jun 2025 07:13:12 PM UTC (every 1s) > n_dead_tup | 1290579 > autoanalyze_count | 3079 > I don't understand where this large

Sudden increase in n_dead_tup with no corresponding insert/update/delete

2025-06-03 Thread Matthew Tice
Hi all, While investigating some potential vacuum improvements to make to a table I happened to notice that one table (along with others) will suddenly increase the number of n_dead_tup reported in pg_stat_user_tables without a corresponding increase in the inserts, updates, or deletes. For in