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.orghttp://dalibo.com
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