DB> Folks,
DB> Is there a catalog table or location where I can go to find data counts for
DB> tables?
DB> It would be nice if I could do a query which returned something like:
DB> table_name #Rows
DB> cust 1000
DB> order 5000
DB> order_detail 9500
DB> without having to have the overhead of querying each table in turn.
DB> If there is such a source then is it accurate as of now or last vacuum or
DB> ???
The pg_class table has a reltuples field but only the vacuum process updates it.
DAQ