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. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org