Re: Identifying bloated tables

Поиск
Список
Период
Сортировка
От Markus Schaber
Тема Re: Identifying bloated tables
Дата
Msg-id 44F31088.5040602@logix-tt.com
обсуждение исходный текст
Ответ на Identifying bloated tables  (Michal Taborsky - Internet Mall <michal.taborsky@mall.cz>)
Ответы Re: Identifying bloated tables
Список pgsql-performance
Hi, Michal,

Michal Taborsky - Internet Mall wrote:

> When using this view, you are interested in tables, which have the
> "bloat" column higher that say 2.0 (in freshly dump/restored/analyzed
> database they should all be around 1.0).

I just noticed some columns in pg_catalog with a bloat value <1 and a
negative "wasted space" - is this due to the pseudo nature of them?

Markus


--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Identifying bloated tables
Следующее
От: Michal Taborsky - Internet Mall
Дата:
Сообщение: Re: Identifying bloated tables