Re: Vacuum statistics - Mailing list pgsql-performance

From Mark Kirkwood
Subject Re: Vacuum statistics
Date
Msg-id 481D3F0E.3030307@paradise.net.nz
Whole thread Raw
In response to Re: Vacuum statistics  (Francisco Reyes <lists@stringsutils.com>)
List pgsql-performance
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
>> <URL:http://www.postgresql.org/docs/current/static/pgstattuple.html>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

pgsql-performance by date:

Previous
From: Francisco Reyes
Date:
Subject: Re: Vacuum statistics
Next
From: Hannes Dorbath
Date:
Subject: Re: pgPool query cache