Hello 2011/1/19 Ozz Nixon <ozzni...@gmail.com>: > A while back someone answered a question I was running into - poor > performance on count(*) from a table which is constantly growing. The answer > was like looking at oracle's V$ table - and I could get a semi-current count. > (I do not need the exact count - just checking to make sure the table is > growing).
http://www.commandprompt.com/community/pgdocs81/planner-stats-details column reltuples in table pg_class. Regards Pavel Stehule > > Ozz > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
