Horton

Re: Huge Data

Richard Huxton <dev@archonet.com>

View thread View on postgr.es
From: Richard Huxton <dev@archonet.com>
To: Sezai YILMAZ <sezai.yilmaz@pro-g.com.tr>, pgsql-general@postgresql.org
Date: 2004-01-14T13:19:46Z
Lists: pgsql-general 
On Wednesday 14 January 2004 12:27, Sezai YILMAZ wrote:
> Richard Huxton wrote:
> >There's plenty on this in the archives, and probably the FAQ too.
> >
> >What are you using the count() for?
>
> I use count() for some statistics. Just to show how many records
> collected so far.

If you want an accurate number without scanning the table, you'll need to use 
a trigger to keep a count up to date.

-- 
  Richard Huxton
  Archonet Ltd