Re: reltuples < # of rows

Eric Brown <eric(dot)brown(at)propel(dot)com> writes:
> I thought that the number of tuples in a table must be greater than the
> number of rows? For one of my tables, I have the following:
> # analyze t_stats;
> ANALYZE
> siteserverdb=# select reltuples, relpages from pg_class where relname =
> 't_stats';
> reltuples | relpages
> -----------+----------
> 1760 | 21119
> (1 row)

> siteserverdb=# select count(*) from t_stats;
> count
> -------
> 1861
> (1 row)

> How is this possible?

ANALYZE produces only an estimated reltuples. To be exact it would have
to scan the entire table.

regards, tom lane