Re: pg_class table problem - Mailing list pgsql-general

From Shilong Stanley Yao
Subject Re: pg_class table problem
Date
Msg-id 4058DD88.5080601@noao.edu
Whole thread Raw
In response to pg_class table problem  (Shilong Stanley Yao <yao@noao.edu>)
List pgsql-general

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

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: pg_class table problem
Next
From: Mark Harrison
Date:
Subject: any sql for doing radix conversion?