pg_class : reltuples

From: Sandeep Joshi <sjoshi(at)Zambeel(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_class : reltuples
Date: 2000-11-22 20:05:16
Message-ID: 3A1C26FC.82DEDFC6@zambeel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message j.logsdon 2000-11-22 20:17:33 Getting started on Linux RH6.2 ...
Previous Message Sandeep Joshi 2000-11-22 19:20:11 Re: copy table from...