pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
monitoring fragmentation
2+ messages / 2 participants
[nested] [flat]

* monitoring fragmentation
@ 2008-01-30 18:33 Kasia Tuszynska <ktuszynska@esri.com>
  2008-01-31 00:52 ` Re: monitoring fragmentation Guillaume Lelarge <guillaume@lelarge.info>
  0 siblings, 1 reply; 2+ messages in thread

From: Kasia Tuszynska @ 2008-01-30 18:33 UTC (permalink / raw)
  To: pgsql-admin

Hi Everybody,

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
- 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. 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.

Sincerely,
Kasia 



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: monitoring fragmentation
  2008-01-30 18:33 monitoring fragmentation Kasia Tuszynska <ktuszynska@esri.com>
@ 2008-01-31 00:52 ` Guillaume Lelarge <guillaume@lelarge.info>
  0 siblings, 0 replies; 2+ messages in thread

From: Guillaume Lelarge @ 2008-01-31 00:52 UTC (permalink / raw)
  To: Kasia Tuszynska <ktuszynska@esri.com>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2008-01-31 00:52 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-01-30 18:33 monitoring fragmentation Kasia Tuszynska <ktuszynska@esri.com>
2008-01-31 00:52 ` Guillaume Lelarge <guillaume@lelarge.info>

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