Vacuum non-clustered tables only

Поиск
Список
Период
Сортировка
От Glen Parker
Тема Vacuum non-clustered tables only
Дата
Msg-id 464B885B.7040803@nwlink.com
обсуждение исходный текст
Ответы Re: Vacuum non-clustered tables only  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Vacuum non-clustered tables only  ("Jim C. Nasby" <decibel@decibel.org>)
Re: Vacuum non-clustered tables only  (Richard Huxton <dev@archonet.com>)
Re: Vacuum non-clustered tables only  (Reece Hart <reece@harts.net>)
Список pgsql-general
I think I know the answer to this, but...

Is there a semi-easy way vacuum all tables in a database *except* those
that are clustered?

(VACUUM [full]; CLUSTER;) is a huge waste of time and resources when you
have clustered tables.  If there isn't a way to do this, can we consider
it a feature request?

Perhaps "VACUUM unclustered" or something?


-Glen


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

Предыдущее
От: Brian Wipf
Дата:
Сообщение: Re: Performance issues of one vs. two split tables.
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Vacuum non-clustered tables only