"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!