From: | "Kasia Tuszynska" <ktuszynska(at)esri(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | monitoring fragmentation |
Date: | 2008-01-30 18:33:13 |
Message-ID: | D7BFFE348C53EF4E8AA0698B1E395FA90C52F33C@flybywire.esri.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2008-01-31 00:52:34 | Re: monitoring fragmentation |
Previous Message | Chander Ganesan | 2008-01-30 15:06:06 | Re: [GENERAL] Can we have 2 databases on same server |
From | Date | Subject | |
---|---|---|---|
Next Message | Sigurd Nes | 2008-01-30 18:34:31 | XML-support |
Previous Message | Joshua D. Drake | 2008-01-30 18:31:20 | Re: postgresql book - practical or something newer? |