Is relpages always supposed to be right?
Started by Alex Turnerover 19 years ago2 messagesgeneral
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
Re: Is relpages always supposed to be right?
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