| From: | Mark Kirkwood <markir(at)paradise(dot)net(dot)nz> |
|---|---|
| To: | Francisco Reyes <lists(at)stringsutils(dot)com> |
| Cc: | chirag(dot)dave(at)gmail(dot)com, Pgsql performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Vacuum statistics |
| Date: | 2008-05-04 04:43:58 |
| Message-ID: | 481D3F0E.3030307@paradise.net.nz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Francisco Reyes wrote:
> chirag(dot)dave(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hannes Dorbath | 2008-05-04 11:13:07 | Re: pgPool query cache |
| Previous Message | Francisco Reyes | 2008-05-04 02:15:11 | Re: Vacuum statistics |