Re: Vacuum and Vacuum analyze

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Vacuum and Vacuum analyze
Дата
Msg-id 20030630140104.GB26591@wolff.to
обсуждение исходный текст
Ответ на Vacuum and Vacuum analyze  ("Chris Boget" <chris@wild.net>)
Список pgsql-novice
On Mon, Jun 30, 2003 at 08:49:28 -0500,
  Chris Boget <chris@wild.net> wrote:
>
> So that begs the question (from a newbie), when should these
> commands, 'vacuum' and 'vacuum analyze' be run and how
> often?

The purpose of vacuum is to allow the space used by deleted (included
old versions of updated tuples) to be reused. You want to do this once
a significant fraction of your database is taken up by deleted tuples.

The purpose of analyze is to provide statistics to the planner so that
a good plan for handling queries. You generally need to run analyze
after the number of rows or distribution of your data changes signicantly.
Doing an initial load is a significant change.

You can run these commands on just some of your tables. This is helpful
when you have a large database where some tables change differently than
others.

Have you read the admin part of the documentation yet?

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

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: Noobie: Problems with a query
Следующее
От: "Frank Lee"
Дата:
Сообщение: jobs mailling list: pgsql-jobs@postgresql.org ?