Re: vacuumdb and a long list of tables - Mailing list pgsql-admin

From Ron Johnson
Subject Re: vacuumdb and a long list of tables
Date
Msg-id CANzqJaAncoQQ=nwpM7QTYXFZwO6gf-buNKZ--s2qtGvxFQubgQ@mail.gmail.com
Whole thread Raw
In response to Re: vacuumdb and a long list of tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
On Sun, Feb 23, 2025 at 3:21 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Ron Johnson <ronljohnsonjr@gmail.com> writes:
> Is there any specific order by which "vacuumdb -t t1 -t t2 -t t3 ..."
> processes those tables?

A quick look at the source code finds

        appendPQExpBufferStr(&catalog_query, " ORDER BY c.relpages DESC;");

so apparently it's trying to process them in descending size order,
although this doesn't account for indexes or toast tables.

Toast tables... when I wrote my email, I was wondering about that.  TOAST is what comprises the "bigness" of the 800 lb gorillas, but combining table plus toast would be pretty messy.

Thanks.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: vacuumdb and a long list of tables
Next
From: richard@kojedz.in
Date:
Subject: Re: In-place upgrade with streaming replicas