Re: counting tupples - Mailing list pgsql-admin

From
Subject Re: counting tupples
Date
Msg-id 1292.203.145.130.142.1035818497.squirrel@mail.trade-india.com
Whole thread Raw
In response to counting tupples  (David Bear <iddwb@moroni.pp.asu.edu>)
List pgsql-admin

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/



pgsql-admin by date:

Previous
From:
Date:
Subject: Re: Strange..!!! Can u tell me why this ?
Next
From: Stephan Szabo
Date:
Subject: Re: Strange..!!! Can u tell me why this ?