Re: vacuumdb and a long list of tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: vacuumdb and a long list of tables
Date: 2025-02-23 20:21:35
Message-ID: 1190571.1740342095@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2025-02-23 20:44:57 Re: vacuumdb and a long list of tables
Previous Message Ron Johnson 2025-02-23 18:09:21 vacuumdb and a long list of tables