optimization

From: sqyang <sqyang(at)nudt(dot)edu(dot)cn>
To: pgsql-sql(at)postgresql(dot)org
Subject: optimization
Date: 1998-11-21 08:02:15
Message-ID: 36567387.2EC9C733@nudt.edu.cn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi:
I create a table tenk. Then I loaded 5000 tuples from a data file to
the table by 'copy' command. The command is as follows: "copy tenk from
'/home/post64/test/t100000.dat' using delimiters ',';". Then I lookup
the pg_class to see some statistic informations about the table such as
tuple number and page number etc. The command is:"select * from pg_class
where relname = 'tenk'". But suprisly,values of these two fields are 0.
Are these statistic information are maintained?
Thanks in advance!

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 1998-11-21 19:01:16 Re: How do I COPY empty Datetimes?
Previous Message anil 1998-11-21 06:21:46 Inheritance