Enrico Pirozzi wrote: > and i would like to retrieve the number of records without make > > select count(*) from table > > I could use directly the table instead of select, and in this this > case I'm searching for > something like the reltuples field in the pg_class table, but I need > this value in real time.
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. Lots of discussion in the mailing-list archives on this. -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
