Re: [postgis-devel] CLUSTER in 8.3 on GIST indexes break - Mailing list pgsql-hackers

From Gregory Stark
Subject Re: [postgis-devel] CLUSTER in 8.3 on GIST indexes break
Date
Msg-id 87fxl2vblp.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: [postgis-devel] CLUSTER in 8.3 on GIST indexes break  (Kevin Neufeld <kneufeld@refractions.net>)
List pgsql-hackers
"Robert W. Burgholzer" <rburghol@vt.edu> writes:

> FWIW,
> I have experienced some oddities in performing SELECT statements after
> restarting on an 8.2 system, whereby I occasionally would get a ton of
> duplicate records when I would do a select statement (my assumption is that
> they are deleted tuples being returned).  If I executed the same select
> statement again, I would get the correct number of records.

Sounds like this item fixed in 8.2.10:

# Fix possible duplicate output of tuples during a GiST index scan (Teodor)

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support!


pgsql-hackers by date:

Previous
From: Kurt Harriman
Date:
Subject: Re: Mostly Harmless: Welcoming our C++ friends
Next
From: "Kevin Grittner"
Date:
Subject: Re: Simple postgresql.conf wizard