Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id AB3BD2E0035 for ; Sun, 4 May 2008 01:59:41 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 59257-01 for ; Sun, 4 May 2008 01:59:37 -0300 (ADT) X-Greylist: delayed 00:15:28.801571 by SQLgrey-1.7.5 Received: from smtp4.clear.net.nz (smtp4.clear.net.nz [203.97.37.64]) by developer.postgresql.org (Postfix) with ESMTP id F0CBB2E002D for ; Sun, 4 May 2008 01:59:35 -0300 (ADT) Received: from zmori.markir.net (121-73-161-26.dsl.telstraclear.net [121.73.161.26]) by smtp4.clear.net.nz (CLEAR Net Mail) with ESMTP id <0K0B000E6UHHT530@smtp4.clear.net.nz> for pgsql-performance@postgresql.org; Sun, 04 May 2008 16:44:07 +1200 (NZST) Date: Sun, 04 May 2008 16:43:58 +1200 From: Mark Kirkwood Subject: Re: Vacuum statistics In-reply-to: To: Francisco Reyes Cc: chirag.dave@gmail.com, Pgsql performance Message-id: <481D3F0E.3030307@paradise.net.nz> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7bit References: User-Agent: Thunderbird 2.0.0.9 (X11/20080419) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/43 X-Sequence-Number: 30011 Francisco Reyes wrote: > chirag.dave@gmail.com writes: > >> What version of Postgres you are running ? > > 8.2 > >> If you are using 8.3, you can use pg_stat_all_tables.If Not you can >> use >> http:// >> www.postgresql.org/docs/current/static/pgstattuple.html > > pgstattuple is also a 8.3 function. Anything simmilar to it in 8.2? > It is available as a contrib module in 8.2, but needs to be installed (see contrib/pgstattuple). regards Mark