Re: pg_class : reltuples - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_class : reltuples
Date
Msg-id 18391.974924420@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_class : reltuples  (Sandeep Joshi <sjoshi@Zambeel.com>)
List pgsql-general
Sandeep Joshi <sjoshi@Zambeel.com> writes:
> I had to run "vacuum" to get corect no.s.  Why is that? I thought
> "pg_class" will be upto date.

reltuples and relpages are just updated by vacuum (and maybe create
index).  They're not intended to be accurate values, only approximate
statistics.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: trouble migrating from 6.3.2 (IRIX) to 7.0.2 (Linux)
Next
From: j.logsdon@lancaster.ac.uk
Date:
Subject: Getting started on Linux RH6.2 ...