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

Re: Index Bloat - how to tell?

From: Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Dave Crooke <dcrooke(at)gmail(dot)com>, "Plugge, Joe R(dot)" <JRPlugge(at)west(dot)com>, John W Strange <john(dot)w(dot)strange(at)jpmchase(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Index Bloat - how to tell?
Date: 2010-12-18 03:56:01
Message-ID: 4D0C30D1.4020102@vmsinfo.com (view raw or flat)
Thread:
Lists: pgsql-performance
Robert Haas wrote:
>
> This doesn't really match my definition of the word "fragmentation", though...
>
>   
Same here. However, I did run "reindex" on one table and this indicator 
did drop to 0. I will shoot an email to the author, he's probably 
smarter than me and will be able to provide a reasonable explanation.

-- 
Mladen Gogala 
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com 


In response to

pgsql-performance by date

Next:From: Gael Le MignotDate: 2010-12-18 08:38:41
Subject: Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows
Previous:From: Robert HaasDate: 2010-12-18 02:46:55
Subject: Re: Strange optimization - xmin,xmax compression :)

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