reindex in v8.2

Поиск
Список
Период
Сортировка
От Bill Willits
Тема reindex in v8.2
Дата
Msg-id 004201c7b299$4ceb7bf0$b601a8c0@bwlaptop
обсуждение исходный текст
Ответы Re: reindex in v8.2  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: reindex in v8.2  (Dan Harris <fbsd@drivefaster.net>)
Список pgsql-admin
Hello:
 
We are in the process of upgrading posgres from v7.3.9 to v8.2.4  In our current environment (v7.3), we run a reindex operation on all tables to recover space and improve performance (we have several tables with high insert/update load - no deletes).  Is it likely that the reindex will still be beneficial after the upgrade?  Or has the pg code changed such that this operation is obsolete?
 
Thanks in advance.
Bill Willits

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: archive_command does not execute
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: reindex in v8.2