On 4/29/24 08:51, Cocam' server wrote:
> > Did the above work for each table?
> Yes, except for the biggest table
>
> > Have you done something like?:
> >
> > select relname, n_dead_tup from pg_stat_all_tables where relname =
> > '<table_name>';
>
> I hadn't thought of that, but it seems that some tables have dead tuples
>
You have something against providing actual numbers?
The point is there is really nothing to be gained by doing VACUUM FULL
if the dead tuples are some small percentage of the tables.
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com