Re: excluding tables from VACUUM ANALYZE

Поиск
Список
Период
Сортировка
От David Fetter
Тема Re: excluding tables from VACUUM ANALYZE
Дата
Msg-id 20081030140417.GQ18097@fetter.org
обсуждение исходный текст
Ответ на excluding tables from VACUUM ANALYZE  ("Igor Neyman" <ineyman@perceptron.com>)
Список pgsql-general
On Thu, Oct 30, 2008 at 09:17:00AM -0400, Igor Neyman wrote:
> This question didn't get any "traction on "admin" list, so I'll try
> here:
>
> I want to analyze the entire database with the exception of several
> tables.  When I run "VACUUM ANALYZE" (or "vacuumdb -z") on the
> database, how can

Why are you doing this in the first place?  Autovacuum works just
great for modern PostgreSQL versions, and if you're not using one of
those, you should be planning your migration, not propping up the old
one :)

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

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

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: Schema Upgrade Howto
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: Are there plans to add data compression feature to postgresql?