Re: Identifying bloated tables - Mailing list pgsql-performance

From Markus Schaber
Subject Re: Identifying bloated tables
Date
Msg-id 44F31088.5040602@logix-tt.com
Whole thread Raw
In response to Identifying bloated tables  (Michal Taborsky - Internet Mall <michal.taborsky@mall.cz>)
Responses Re: Identifying bloated tables  (Michal Taborsky - Internet Mall <michal.taborsky@mall.cz>)
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Identifying bloated tables
Next
From: Michal Taborsky - Internet Mall
Date:
Subject: Re: Identifying bloated tables