Hi folks,
There is "reltuples" in pg_class which is approximately equal to
select count(*) from relation.
i think its updated only on VACUUMING ?
(david its not answer to ur question sorry)
regds
mallah.
> I couldn't find anything relating to getting the cardinality of a table. I know a select will
> display number of rows. I was hoping there was a 'cheaper' (less expensive) way than doing a
> full select.
> --
> David Bear
> College of Public Programs/ASU
>
> ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and
> unsubscribe commands go to majordomo@postgresql.org
-----------------------------------------
Get your free web based email at trade-india.com.
"India's Leading B2B eMarketplace.!"
http://www.trade-india.com/