Re: count * performance issue

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: sathiya psql <sathiya(dot)psql(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: count * performance issue
Date: 2008-03-06 13:18:17
Message-ID: Pine.GSO.4.64.0803060813570.11897@westnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2008-03-06 13:27:14 Re: count * performance issue
Previous Message Mark Mielke 2008-03-06 13:10:35 Re: count * performance issue