Re: count * performance issue - Mailing list pgsql-performance

From Andrew Sullivan
Subject Re: count * performance issue
Date
Msg-id 20080311143439.GA1465@crankycanuck.ca
Whole thread Raw
In response to Re: count * performance issue  (Matthew <matthew@flymine.org>)
List pgsql-performance
On Tue, Mar 11, 2008 at 02:19:09PM +0000, Matthew wrote:
> of rows with IS NULL, then someone changes a row, then you find the count
> of rows with IS NOT NULL. Add the two together, and there may be rows that
> were counted twice, or not at all.

Only if you count in READ COMMITTED.

A


pgsql-performance by date:

Previous
From: "Heikki Linnakangas"
Date:
Subject: Re: count * performance issue
Next
From: "Kynn Jones"
Date:
Subject: Re: Joins and DELETE FROM