VACUUM/VACUUM FULL/REINDEX

Поиск
Список
Период
Сортировка
От Sam Barnett-Cormack
Тема VACUUM/VACUUM FULL/REINDEX
Дата
Msg-id Pine.LNX.4.50.0308010955350.6415-100000@short.lancs.ac.uk
обсуждение исходный текст
Ответы Re: VACUUM/VACUUM FULL/REINDEX  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
I'm a little confused about comments I've seen on this list - a VACUUM
is not enough, clearly, to maintain a trim, efficient DB. People have
mentioned that REINDEX is also needed periodically. Is this the case
even if one VACUUM FULL's periodically, or does that effectively REINDEX
also?

--

Sam Barnett-Cormack
Software Developer                           |  Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk)  |  Lancaster University

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

Предыдущее
От: Sam Barnett-Cormack
Дата:
Сообщение: Re: Partitioning tables...
Следующее
От: Mauri Sahlberg
Дата:
Сообщение: Re: Parallel transactions failing oddly