Need for rebuilding index after many deletions?

Поиск
Список
Период
Сортировка
От Patrick Robin
Тема Need for rebuilding index after many deletions?
Дата
Msg-id 398AE87D.8D1A913@fa.disney.com
обсуждение исходный текст
Ответ на Embedded SQL C++ preprocessor ?  ("luc00" <lucian00@hotpop.com>)
Список pgsql-general
Hi all,

   With Postgres 6.5.2,  if a table has undergone several row deletions,
does it make sense/ is it needed  to rebuild the index?  Would this be
accomplished by
dropping it and then recreating it?

Thanks

Patrick



--
________________________________________
Patrick Robin
patrickr@fa.disney.com
Walt Disney Feature Animation
500 South Buena Vista Street
Burbank,California 91521-4817




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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] pg_dump/restore to convert BLOBs to LZTEXT (optiona l!)
Следующее
От: Craig Anderson
Дата:
Сообщение: Database Connection Restriction Problems