hubert depesz lubaczewski <depesz@xxxxxxxxxx> writes: > 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: I was just going to ask you to check that. Weird as can be. Does plain old "SELECT COUNT(*)" show a difference between the two tables? Do you get similar misbehavior if you break the CREATE TABLE AS into a CREATE and an INSERT/SELECT? Also, please note the rowcount returned by INSERT/SELECT and see how it matches up with the tables afterwards. Does turning synchronize_seqscans off affect the behavior? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
