monitoring fragmentation
| От | Kasia Tuszynska |
|---|---|
| Тема | monitoring fragmentation |
| Дата | |
| Msg-id | D7BFFE348C53EF4E8AA0698B1E395FA90C52F33C@flybywire.esri.com обсуждение исходный текст |
| Ответ на | Re: how to create cluster(loadbanacing) of postgresql server (Markus Schiltknecht <markus@bluegap.ch>) |
| Ответы |
Re: monitoring fragmentation
|
| Список | 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
В списке pgsql-admin по дате отправления: