pg_class : reltuples - Mailing list pgsql-general

From Sandeep Joshi
Subject pg_class : reltuples
Date
Msg-id 3A1C26FC.82DEDFC6@zambeel.com
Whole thread Raw
List pgsql-general
What does "reltuples" from pg_class represent?
any comments
Here is something that raised this question:

---------------------------------------
testdb=# select count(*) from zuser3;
  count
---------
 1000000
(1 row)

testdb=#  select count(*) from zuser2;
 count
--------
 100000
(1 row)

testdb=# select count(*) from zuser1;
 count
-------
  1000select relname,relpages,reltuples from pg_class where relname like
'zuse%';
 relname | relpages | reltuples
---------+----------+-----------
 zuser2  |       10 |      1000
 zuser1  |       10 |      1000
 zuser3  |       10 |      1000
(3 rows)

(1 row)



pgsql-general by date:

Previous
From: "Roger T. Alexander"
Date:
Subject: Compiling PostGresQL under Win2k
Next
From: George Armhold
Date:
Subject: trouble migrating from 6.3.2 (IRIX) to 7.0.2 (Linux)