From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Ozz Nixon <ozznixon(at)gmail(dot)com> |
Cc: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Another table/column has semi-current COUNTs? |
Date: | 2011-01-19 06:09:34 |
Message-ID: | AANLkTimVo2ATBxB9tdEGVL9ijFPpxWNz+a_2_rJvNvnm@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello
2011/1/19 Ozz Nixon <ozznixon(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2011-01-19 10:00:01 | Re: Getting a sample data set. |
Previous Message | raf | 2011-01-19 03:15:08 | Re: help understanding collation order |