pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
monitoring fragmentation 2+ messages / 2 participants [nested] [flat]
* monitoring fragmentation @ 2008-01-30 18:33 Kasia Tuszynska <ktuszynska@esri.com> 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-31 00:52 Guillaume Lelarge <guillaume@lelarge.info> parent: Kasia Tuszynska <ktuszynska@esri.com> 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