On 3 November 2011 15:15, hubert depesz lubaczewski <depesz@xxxxxxxxxx> wrote: >> Do the xobject_id values have other negative numbers or is -1 just a special >> case? The only thing I can think of is a corrupted index on xobject_id. > > minimal xobject_id in source table is 1000. > > index on xobject_id might be corrupted, but it doesn't explain that I > don't see duplicates with group_by/having query on xobjects, which uses > seqscan: Actually, it does. A sequential scan doesn't use the index. -- If you can't see the forest for the trees, Cut the trees and you'll see there is no forest. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
