Re: Bloated Table - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Bloated Table
Date
Msg-id 20090527200226.GZ32650@alvh.no-ip.org
Whole thread Raw
In response to Re: Bloated Table  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Bloated Table
List pgsql-general
Tom Lane wrote:

> It's an interesting exercise in trying to estimate bloat without
> groveling through the whole relation, but I seriously doubt you could
> ever get numbers this way that are trustworthy enough to drive
> maintenance decisions.

Well, pg_stattuple is way too expensive to be running every minute ...

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Alan McKay
Date:
Subject: Re: [PERFORM] Postgres Clustering
Next
From: Tom Lane
Date:
Subject: Re: Multidimensional array definition in composite type appears parsed as string