On 1 Aug 2003 at 9:14, Ron Johnson wrote:
> On Thu, 2003-07-31 at 23:23, Dennis Gearon wrote:
> > It will only be at a given point in time, since datasbases are by
> > design, realtime/concurrent applications.
> >
> > do:
> >
> > SELECT COUNT(*) FROM table_name;
> >
> > Should give you what you want.
>
> It'll give him what he wants, but not quickly, if it's a 10/20/etc
> M row table.
>
> One hack is:
> CREATE TABLE T_CARDINALITY (
> RELATION_NAME CHAR(31) PRIMARY KEY,
> CARDINALITY BIGINT );
How about
select reltuples from pg_class where relname='mytablename';
It is as accurate as your last vacuum..
Bye
Shridhar
--
Strategy: A long-range plan whose merit cannot be evaluated until sometime
after those creating it have left the organization.
