| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Shilong Stanley Yao <yao(at)noao(dot)edu> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_class table problem |
| Date: | 2004-03-17 22:49:21 |
| Message-ID: | 20040317224918.GA18987@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)svana(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shilong Stanley Yao | 2004-03-17 23:21:44 | Re: pg_class table problem |
| Previous Message | Shilong Stanley Yao | 2004-03-17 22:29:33 | pg_class table problem |