Thread: Is relpages always supposed to be right?

Is relpages always supposed to be right?:

select count(*) from result_entry;

trend=# select count(*) from result_entry;
 count
-------
 59913
(1 row)

trend=# select relpages from pg_class where relname='result_entry';
 relpages
----------
        0
(1 row)

trend=#


Alex

Alex Turner wrote:
> Is relpages always supposed to be right?:

No, it's only updated on VACUUM, ANALYZE, CREATE INDEX, and perhaps
REINDEX.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support