Re: Records Number - Mailing list pgsql-general

From Enrico Pirozzi
Subject Re: Records Number
Date
Msg-id 5d038c780903170709s18793918g1b82e06996951d1a@mail.gmail.com
Whole thread Raw
In response to Re: Records Number  (Richard Huxton <dev@archonet.com>)
List pgsql-general
> If you want an accurate, up-to-date count then you'll need to use
> count(*) or have a trigger keep a summary-count for you. A simple
> implementation will reduce concurrency to writes on that table however.

Yes I solved by a trigger....

> Lots of discussion in the mailing-list archives on this.

Thank you for your time

Enrico




--
That's one small step for man; one giant leap for mankind

Enrico Pirozzi
Tel.  +39 0861 1855771
Mob.+39 328 4164437
Fax  +39 0861 1850310
www.enricopirozzi.info
info@enricopirozzi.info
Skype sscotty71

pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Uploading data to postgresql database
Next
From: Marco Colombo
Date:
Subject: Re: Maximum transaction rate