On Thu, 6 Mar 2008, sathiya psql wrote:
is there any article saying the difference between this 7.3 and 8.4
I've collected a list of everything on this topic I've seen at http://www.postgresqldocs.org/index.php/Version_8.3_Changes
The Feature Matrix linked to there will be a quicker way to see what's happened than sorting through the release notes.
None of these changes change the fact that getting an exact count in this situation takes either a sequential scan or triggers.
-- * Greg Smith gsmith@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-performance