Re: vacuumdb and a long list of tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: vacuumdb and a long list of tables
Дата
Msg-id 1190571.1740342095@sss.pgh.pa.us
обсуждение исходный текст
Ответ на vacuumdb and a long list of tables  (Ron Johnson <ronljohnsonjr@gmail.com>)
Ответы Re: vacuumdb and a long list of tables
Список 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



В списке pgsql-admin по дате отправления: