"Robert W. Burgholzer" <[EMAIL PROTECTED]> 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! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers