Re: Spped of max - Mailing list pgsql-general

From Tom Lane
Subject Re: Spped of max
Date
Msg-id 29766.1021517488@sss.pgh.pa.us
Whole thread Raw
In response to Re: Spped of max  (Andy DePue <adepue@eworksmart.com>)
List pgsql-general
Andy DePue <adepue@eworksmart.com> writes:
>   Just curious... but often, I have only needed a "fairly" accurate
> count of rows.  As in, outside the context of a transaction.  In other
> words, how difficult would it be to keep track of the number of fully
> committed and visible rows in a table?

Well, if you run vacuum (or analyze) on a reasonably frequent basis,
seems like pg_class.reltuples would do fine.

            regards, tom lane

pgsql-general by date:

Previous
From: "patrick k ."
Date:
Subject: How to include PostgreSQL Copyright notice
Next
From: Thomas Lockhart
Date:
Subject: Re: How to include PostgreSQL Copyright notice