Received: from sdns.nudt.edu.cn (sdns.nudt.edu.cn [202.197.0.181]) by hub.org (8.9.1/8.9.1) with ESMTP id CAA12658 for ; Wed, 18 Nov 1998 02:59:37 -0500 (EST) (envelope-from sqyang@nudt.edu.cn) Received: from ysq ([202.197.11.54]) by sdns.nudt.edu.cn (Netscape Messaging Server 3.5) with SMTP id AAA17B3 for ; Wed, 18 Nov 1998 16:02:35 +0800 Sender: post64 Message-ID: <36567387.2EC9C733@nudt.edu.cn> Date: Sat, 21 Nov 1998 16:02:15 +0800 From: sqyang Organization: GalaxyDB Cor. X-Mailer: Mozilla 3.01Gold (X11; I; Linux 2.0.30 i686) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: optimization Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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!