Re: pg_class table problem - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: pg_class table problem
Date
Msg-id 20040317224918.GA18987@svana.org
Whole thread Raw
In response to pg_class table problem  (Shilong Stanley Yao <yao@noao.edu>)
List pgsql-general
On Wed, Mar 17, 2004 at 03:29:33PM -0700, Shilong Stanley Yao wrote:
> Hi,
> I inserted thousands of records in a table, but when using "select
> relname, relpages from pg_class;", the number of pages of the table in
> which I am inserting records is always 10, which is the same as an empty
> table.  Am I doing anything wrong? Thanks, -Stan

These figures are updated by VACUUM and possibly by ANALYZE also.

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> If the Catholic church can survive the printing press, science fiction
> will certainly weather the advent of bookwarez.
>    http://craphound.com/ebooksneitherenorbooks.txt - Cory Doctorow

Attachment

pgsql-general by date:

Previous
From: Shilong Stanley Yao
Date:
Subject: pg_class table problem
Next
From: Shilong Stanley Yao
Date:
Subject: Re: pg_class table problem