Postgres Pro
Downloads
Home   >   mailing lists

Re: Strange problem with create table as select * from table; - Mailing list pgsql-general

From Tom Lane
Subject Re: Strange problem with create table as select * from table;
Date
Msg-id 19381.1320332120@sss.pgh.pa.us
Whole thread Raw
In response to Re: Strange problem with create table as select * from table;  (hubert depesz lubaczewski <depesz@depesz.com>)
Responses Re: Strange problem with create table as select * from table;  (hubert depesz lubaczewski <depesz@depesz.com>)
Re: Strange problem with create table as select * from table;  (hubert depesz lubaczewski <depesz@depesz.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Ioana Danes
Date:
Subject: Re: Memory Issue
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Strange problem with create table as select * from table;