pg_repack and table statistics

From: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: pg_repack and table statistics
Date: 2024-08-29 04:16:31
Message-ID: CAOC+FBVsecrnc-dzt-pZ-orMe2i=kxZ9WHBFQrk6_PEu7zyniw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I find that the n_dead_tup value in pg_stat_user_tables is the same before
and after a successful pg_repack of that table (ditto all the values
really). Is there something that should be done after a repack to have
those stats updated, or is their unchanging value a sign of repack failing
for some reason?

--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Wells Oliver 2024-08-29 04:21:12 Re: pg_repack and table statistics
Previous Message SASIKUMAR Devaraj 2024-08-29 03:59:45 Re: Password Change Mandatory during First Login