Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Michal Taborsky - Internet MallDate: 2006-08-28 15:56:08
Subject: Re: Identifying bloated tables
Previous:From: Alvaro HerreraDate: 2006-08-28 15:31:52
Subject: Re: Identifying bloated tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group