Re: Identifying bloated tables

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: Michal Taborsky - Internet Mall <michal(dot)taborsky(at)mall(dot)cz>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Identifying bloated tables
Date: 2006-08-28 15:49:28
Message-ID: 44F31088.5040602@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Michal Taborsky - Internet Mall 2006-08-28 15:56:08 Re: Identifying bloated tables
Previous Message Alvaro Herrera 2006-08-28 15:31:52 Re: Identifying bloated tables