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.
In response to
pgsql-admin by date
|Next:||From: Guillaume Lelarge||Date: 2008-01-31 00:52:34|
|Subject: Re: monitoring fragmentation|
|Previous:||From: Chander Ganesan||Date: 2008-01-30 15:06:06|
|Subject: Re: [GENERAL] Can we have 2 databases on same server|
pgsql-general by date
|Next:||From: Sigurd Nes||Date: 2008-01-30 18:34:31|
|Previous:||From: Joshua D. Drake||Date: 2008-01-30 18:31:20|
|Subject: Re: postgresql book - practical or something newer?|