Dave Crooke <dcrooke@xxxxxxxxx> writes: > 4. If you're trying to figure out the net size of the table, i.e. how much > free space is inside the table files for reuse by PG, then you need the > pg_stat_tuple function ... this is built in to PG 8.4, and a plug-in > activated by a script for PG 8.3, don't know if it exists in 8.1 or not. > Like SELECT COUNT(*) this requires a full table scan. I think what the OP actually wants is the number of live rows, so plain old SELECT COUNT(*) would do it. If that's too slow, a good alternative is to ANALYZE the table and then look at its pg_class.reltuples entry --- of course that will only be an approximate count. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
