Re: Strange problem with create table as select * from table;

hubert depesz lubaczewski <depesz@depesz.com> 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