pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Guillaume Lelarge <guillaume@lelarge.info>
To: Kasia Tuszynska <ktuszynska@esri.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: monitoring fragmentation
Date: Thu, 31 Jan 2008 01:52:34 +0100
Message-ID: <47A11BD2.6070908@lelarge.info> (raw)
In-Reply-To: <D7BFFE348C53EF4E8AA0698B1E395FA90C52F33C@flybywire.esri.com>
References: <38820.10.1.1.53.1201668143.squirrel@10.1.1.31>
	<47A0481A.8070409@bluegap.ch>
	<D7BFFE348C53EF4E8AA0698B1E395FA90C52F33C@flybywire.esri.com>

Kasia Tuszynska wrote:
> I am searching for a pg_xxxxx view that would allow me to view the
> properties of an index. 
> - the fillfactor it was created with

Catalog pg_class, column reloptions.

> - the amount of free space on a page(s) storing the index ( assuming
> that it was created with a fillfactor and the index has incurred updates
> since the creation taking up some space reserved by the fillfactor
> during the load).
> 
> The usage of a fillfactor nor fragmentation info does not get displayed
> in pgAdminIII.

Fillfactor information is available with pgAdmin III 1.8.

  In SQL Server 2005 the analogous views would be:
> Obcc showcontig and sys.dm_index_physical_stats
> 
> Perhaps there is another way to determine fragmentation of indexes in
> Postgres, any hint would be much appreciated.
> 

Try pgstattuple module contrib. See 
http://www.postgresql.org/docs/8.3/static/pgstattuple.html for more 
informations.

Regards.


-- 
Guillaume.
  http://www.postgresqlfr.org
  http://dalibo.com



view thread (2+ messages)

Message-ID: <47A11BD2.6070908@lelarge.info>
Permalink:  ../47A11BD2.6070908@lelarge.info/
Also on:    postgresql.org/message-id/47A11BD2.6070908@lelarge.info

 · 

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-admin@postgresql.org
  Cc: guillaume@lelarge.info, ktuszynska@esri.com
  Subject: Re: monitoring fragmentation
  In-Reply-To: <47A11BD2.6070908@lelarge.info>

* 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