Re: Identifying bloated tables

Поиск
Список
Период
Сортировка
От Brad Nicholson
Тема Re: Identifying bloated tables
Дата
Msg-id 1156776499.10296.5.camel@dba5.int.libertyrms.com
обсуждение исходный текст
Ответ на Identifying bloated tables  (Michal Taborsky - Internet Mall <michal.taborsky@mall.cz>)
Ответы Re: Identifying bloated tables  (Michal Taborsky - Internet Mall <michal.taborsky@mall.cz>)
Re: Identifying bloated tables  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-performance
On Mon, 2006-08-28 at 16:39 +0200, Michal Taborsky - Internet Mall
wrote:
> I just put together a view, which helps us in indentifying which
> database tables are suffering from space bloat, ie. they take up much
> more space than they actually should. I though this might be useful for
> some folk here, because the questions about bloat-related performance
> degradation are quite common.

Are you sure you haven't reinvented the wheel?  Have you checked out
contrib/pgstattuple ?

Brad.


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

Предыдущее
От: Michal Taborsky - Internet Mall
Дата:
Сообщение: Identifying bloated tables
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Postgre SQL 7.1 cygwin performance issue.