Re: Index Bloat - how to tell? - Mailing list pgsql-performance

From Mladen Gogala
Subject Re: Index Bloat - how to tell?
Date
Msg-id 4D0C30D1.4020102@vmsinfo.com
Whole thread Raw
In response to Re: Index Bloat - how to tell?  (Robert Haas <robertmhaas@gmail.com>)
List 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


pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: Strange optimization - xmin,xmax compression :)
Next
From: Gael Le Mignot
Date:
Subject: Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows