A question about Vacuum analyze

Поиск
Список
Период
Сортировка
От Emi Lu
Тема A question about Vacuum analyze
Дата
Msg-id 43F48863.6060501@encs.concordia.ca
обсуждение исходный текст
Ответы Re: A question about Vacuum analyze  (Ragnar <gnari@hive.is>)
Re: A question about Vacuum analyze  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hello,

We have a daily cronjob and in the cronjob we do:
  1.  truncate one table A
  2.  insert into table A
  3.  do comparision table A and table B and update table B accordingly

The doc says "VACUUM ANALYZE command for the affected table. This will
update the system catalogs with the results of all recent changes, and
allow the PostgreSQL query planner to make better choices in planning
queries".
So, I believe after insertion at step 2, comparision will be speed up if
we do a "vacuum analyze" right?

In another way, whenever we "delete/truncate and then insert" data into
a table, it is better to "vacuum anaylze"?

Thanks a lot!
Emi


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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: NULLs in unique indexes; Was: Oracle purchases Sleepycat
Следующее
От: Robert Treat
Дата:
Сообщение: Re: NULLs in unique indexes; Was: Oracle purchases