Sandeep Joshi <[EMAIL PROTECTED]> 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.
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=# s
What does "reltuples" from pg_class represent?
any comments
Here is something that raised this question:
---
testdb=# select count(*) from zuser3;
count
-
100
(1 row)
testdb=# select count(*) from zuser2;
count
10
(1 row)
testdb
