Re: Index bloat problem?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Index bloat problem?
Дата
Msg-id 200504211022.03541.josh@agliodbs.com
обсуждение исходный текст
Ответ на Index bloat problem?  (Bill Chandler <billybobc1210@yahoo.com>)
Ответы Re: Index bloat problem?  (Alex Turner <armtuk@gmail.com>)
Список pgsql-performance
Bill,

> What about if an out-of-the-ordinary number of rows
> were deleted (say 75% of rows in the table, as opposed
> to normal 5%) followed by a 'VACUUM ANALYZE'?  Could
> things get out of whack because of that situation?

Yes.  You'd want to run REINDEX after and event like that.  As you should now.

--
Josh Berkus
Aglio Database Solutions
San Francisco

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

Предыдущее
От: Bill Chandler
Дата:
Сообщение: Index bloat problem?
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: How can an index be larger than a table