Re: [GENERAL] pg_class table problem

[Shilong Stanley Yao]

Marc Durham wrote:
The relpages value is an estimated value I believe.  Try using VACUUM to
update it:
    VACUUM mytable;
    SELECT relname, relpages from pg_class;
-Marc-
Thank you all for your help.  "vacuum" does help!  Now I got the 
accurate numbers. -Stan

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
              http://www.postgresql.org/docs/faqs/FAQ.html