X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 294359FA999 for ; Fri, 23 Jun 2006 13:09:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 37019-04 for ; Fri, 23 Jun 2006 13:09:45 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 641709FA92E for ; Fri, 23 Jun 2006 13:09:45 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k5NG9fRf016265; Fri, 23 Jun 2006 12:09:42 -0400 (EDT) To: luchot@voila.fr cc: pgsql-performance@postgresql.org Subject: Re: Occupation bloc in pages of table In-reply-to: <258525.1151057523099.JavaMail.www@wwinf4002> References: <258525.1151057523099.JavaMail.www@wwinf4002> Comments: In-reply-to luchot message dated "Fri, 23 Jun 2006 12:12:03 +0200" Date: Fri, 23 Jun 2006 12:09:41 -0400 Message-ID: <16264.1151078981@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/464 X-Sequence-Number: 19821 luchot writes: > I would want if it is possible for each pages of a table to have the occupation of blocs in percentage in order to see if the page is good full or not. There is not any magic way of getting that information, but you could modify contrib/pgstattuple to produce such a report. regards, tom lane