pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Mladen Gogala <mladen.gogala@vmsinfo.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Dave Crooke <dcrooke@gmail.com>
Cc: Plugge, Joe R. <JRPlugge@west.com>
Cc: John W Strange <john.w.strange@jpmchase.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Index Bloat - how to tell?
Date: Fri, 17 Dec 2010 22:56:01 -0500
Message-ID: <4D0C30D1.4020102@vmsinfo.com> (raw)
In-Reply-To: <AANLkTikedY0=mBZ4nFm3XQK=u08j59yqPMsrsJqA=fgP@mail.gmail.com>
References: <EF37296944B47C40ADDCCB7BFD6289FE046CDF1BCD@EMASC201VS01.exchad.jpmchase.net>
	<BD69807DAE0CE44CA00A8338D0FDD08302E9548A03@oma00cexmbx03.corp.westworlds.com>
	<AANLkTim9cSXi9iswOUvKM4iifVUMPzURWxAaXt_OHwRW@mail.gmail.com>
	<4D0A680C.7040105@vmsinfo.com>
	<AANLkTikedY0=mBZ4nFm3XQK=u08j59yqPMsrsJqA=fgP@mail.gmail.com>

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 




view thread (8+ messages)

Message-ID: <4D0C30D1.4020102@vmsinfo.com>
Permalink:  ../4D0C30D1.4020102@vmsinfo.com/
Also on:    postgresql.org/message-id/4D0C30D1.4020102@vmsinfo.com

 · 

reply
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: mladen.gogala@vmsinfo.com, robertmhaas@gmail.com, dcrooke@gmail.com, JRPlugge@west.com, john.w.strange@jpmchase.com
  Subject: Re: Index Bloat - how to tell?
  In-Reply-To: <4D0C30D1.4020102@vmsinfo.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