On Tuesday 06 January 2004 01:22, Rod Taylor wrote: > Anyway, with Rules you can force this: > > ON INSERT UPDATE counter SET tablecount = tablecount + 1; > > ON DELETE UPDATE counter SET tablecount = tablecount - 1;
That would generate lot of dead tuples in counter table. How about select relpages,reltuples from pg_class where relname=<tablename>; Assuming the stats are recent enough, it would be much faster and accurate.. Shridhar ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend