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

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.

            regards, tom lane