Re: pg_class : reltuples

I had to run "vacuum" to get corect no.s. Why is that? I thought
"pg_class" will be upto date.
This makes me nervous.

Sandeep

> What does "reltuples" from pg_class represent?
> any comments
> Here is something that raised this question:
>
> ---------------------------------------
> testdb=# select count(*) from zuser3;
> count
> ---------
> 1000000
> (1 row)
>
> testdb=# select count(*) from zuser2;
> count
> --------
> 100000
> (1 row)
>
> testdb=# select count(*) from zuser1;
> count
> -------
> 1000

> select relname,relpages,reltuples from pg_class where relname like
> 'zuse%';
> relname | relpages | reltuples
> ---------+----------+-----------
> zuser2 | 10 | 1000
> zuser1 | 10 | 1000
> zuser3 | 10 | 1000
> (3 rows)
>
> (1 row)