Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 8F9CD2E0095 for ; Wed, 30 Jan 2008 20:52:54 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 47614-06 for ; Wed, 30 Jan 2008 20:52:41 -0400 (AST) Received: from sd-2317.dedibox.fr (sd-2317.dedibox.fr [88.191.17.192]) by postgresql.org (Postfix) with ESMTP id 0BF7B2E008A for ; Wed, 30 Jan 2008 20:52:48 -0400 (AST) Received: from [192.168.10.1] (ASte-Genev-Bois-153-1-21-4.w83-112.abo.wanadoo.fr [83.112.201.4]) by sd-2317.dedibox.fr (Postfix) with ESMTP id 5EF332B32; Thu, 31 Jan 2008 01:52:35 +0100 (CET) Message-ID: <47A11BD2.6070908@lelarge.info> Date: Thu, 31 Jan 2008 01:52:34 +0100 From: Guillaume Lelarge User-Agent: Thunderbird 2.0.0.9 (X11/20071112) MIME-Version: 1.0 To: Kasia Tuszynska CC: pgsql-admin@postgresql.org Subject: Re: monitoring fragmentation References: <38820.10.1.1.53.1201668143.squirrel@10.1.1.31> <47A0481A.8070409@bluegap.ch> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/289 X-Sequence-Number: 28063 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