Обсуждение: optimization

Поиск
Список
Период
Сортировка

optimization

От
sqyang
Дата:
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!