Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id B4E68B5DC09
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Wed, 21 Sep 2011 13:13:04 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 62666-10
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Wed, 21 Sep 2011 16:12:58 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2
Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.8])
	by mail.postgresql.org (Postfix) with ESMTP id 24D2FB5DC24
	for <pgsql-performance@postgresql.org>;
	Wed, 21 Sep 2011 13:12:58 -0300 (ADT)
Received: from [192.168.1.7] (mail.highperformancepostgresql.com
	[71.179.240.8])
	by mrelayeu.kundenserver.de (node=mreu2) with ESMTP (Nemesis)
	id 0LfWo9-1RQf9e49e5-00pZcw; Wed, 21 Sep 2011 18:12:56 +0200
Message-ID: <4E7A0D02.6050808@2ndQuadrant.com>
Date: Wed, 21 Sep 2011 12:12:50 -0400
From: Greg Smith <greg@2ndQuadrant.com>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.1.16) Gecko/20110818 Icedove/3.0.11
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: Show_database_bloat reliability? [was: Re: REINDEX
	not working for wastedspace]
References: 
 <CAGoODpcBxGLyF=bY3_5opO4YckgJqFGwBxveU_cYsrXBbN4NgQ@mail.gmail.com>
	<m37h5283s4.fsf@mnc.ch>
In-Reply-To: <m37h5283s4.fsf@mnc.ch>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Provags-ID: V02:K0:c1XY05ICV+7GRLv+57Ezz/Pz2AnHfcHuwslLbZ4ovJs
	4ppYHqcRdqf9ULc22syj+RdctgrOTARTXcj0QVPJ/XjwiWQ/iw
	4bgtWgRHzRoSpVGCAJg42uebFCVwDLPoEty627tqqgjAISDCFb
	jASAKtGT4JL0GezP+Lwa/UhHvU4ZRPSEsozYqjH1a9RP5Hh7fQ
	pLXftrooq4PCcDH+xO9E1o7qdtc3lNUr0L0UBqs2nSLCJYFbH3
	L5LICB+2a1qipAepBEdZLRu6YrMYEaG50oFZ1qjqvmfhW7qiWF
	jBCuj7glrBuK8jT+A12SDDoIyiAwdP/hxQrc1mk3DJz6hSzud2
	8jzyPSy+PovgxAVSVUbc=
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201109/329
X-Sequence-Number: 45105

On 09/21/2011 08:43 AM, Guillaume Cottenceau wrote:
> AI Rumman<rummandba 'at' gmail.com>  writes:
>
>    
>> Using the query http://wiki.postgresql.org/wiki/Show_database_bloat, I got the
>>      
> Is this stuff to show database bloat reliable?

Only in that increase and decreases of the number reported can be useful 
for determining if bloat is likely increasing or decreasing--which is 
the purpose of that query.  The value returned is a rough estimate, and 
should not be considered useful as any sort of absolute measurement.

-- 
Greg Smith   2ndQuadrant US    greg@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us