Skip site navigation (1) Skip section navigation (2)

Re: counting tupples

From: <mallah(at)trade-india(dot)com>
To: <david(dot)bear(at)asu(dot)edu>
Cc: <iddwb(at)moroni(dot)pp(dot)asu(dot)edu>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: counting tupples
Date: 2002-10-28 15:21:37
Message-ID: 1292.203.145.130.142.1035818497.squirrel@mail.trade-india.com (view raw or flat)
Thread:
Lists: 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(at)postgresql(dot)org



-----------------------------------------
Get your free web based email at trade-india.com.
   "India's Leading B2B eMarketplace.!"
http://www.trade-india.com/



In response to

pgsql-admin by date

Next:From: Stephan SzaboDate: 2002-10-28 16:38:48
Subject: Re: Strange..!!! Can u tell me why this ?
Previous:From: mallahDate: 2002-10-28 14:59:39
Subject: Re: Strange..!!! Can u tell me why this ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group