Re: vacuumdb and a long list of tables

On Sun, Feb 23, 2025 at 3:21 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Ron Johnson <ronljohnsonjr(at)gmail(dot)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!