From: Alan Stange <stange@rentec.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Vivek Khera <vivek@khera.org>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: postgresql performance tuning
Date: Tue, 06 Dec 2005 16:39:59 -0500
Message-ID: <4396052F.9050507@rentec.com> (raw)
In-Reply-To: <16451.1133904057@sss.pgh.pa.us>
References: <Pine.LNX.4.58.0512060941090.21795@karadi.cs.wisc.edu>
<F069CC64-C748-4EC1-ADF3-38D2FBC230CD@khera.org>
<4395F914.8070001@rentec.com>
<16451.1133904057@sss.pgh.pa.us>
Tom Lane wrote:
> Alan Stange <stange@rentec.com> writes:
>
>> Vivek Khera wrote:
>>
>>> what evidence do you have that you are suffering index bloat?
>>>
>
>
>> The files for the two indices on a single table used 7.8GB of space
>> before a reindex, and 4.4GB after.
>>
>
> That's not bloat ... that's pretty nearly in line with the normal
> expectation for a btree index, which is about 2/3rds fill factor.
> If the compacted index were 10X smaller then I'd agree that you have
> a bloat problem.
>
I wrote "I don't think this counts as bloat...". I still don't.
-- Alan
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: stange@rentec.com, tgl@sss.pgh.pa.us, vivek@khera.org
Subject: Re: postgresql performance tuning
In-Reply-To: <4396052F.9050507@rentec.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox