Re: Huge Data - Mailing list pgsql-general

From Richard Huxton
Subject Re: Huge Data
Date
Msg-id 200401141319.46326.dev@archonet.com
Whole thread Raw
In response to Re: Huge Data  (Sezai YILMAZ <sezai.yilmaz@pro-g.com.tr>)
List 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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Huge Data
Next
From: Sezai YILMAZ
Date:
Subject: Re: Huge Data