From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
---|---|
To: | Alban Hertroys <haramrae(at)gmail(dot)com> |
Cc: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Strange problem with create table as select * from table; |
Date: | 2011-11-03 14:21:42 |
Message-ID: | 20111103142141.GA21264@depesz.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
On Thu, Nov 03, 2011 at 03:19:36PM +0100, Alban Hertroys wrote:
> On 3 November 2011 15:15, hubert depesz lubaczewski <depesz(at)depesz(dot)com> 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.
sure. but so isn't create table as.
Best regards,
depesz
--
The best thing about modern society is how easy it is to avoid contact with it.
http://depesz.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2011-11-03 14:30:27 | Re: Memory Issue |
Previous Message | Alban Hertroys | 2011-11-03 14:19:36 | Re: Strange problem with create table as select * from table; |
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2011-11-03 14:22:48 | Re: heap vacuum & cleanup locks |
Previous Message | Alban Hertroys | 2011-11-03 14:19:36 | Re: Strange problem with create table as select * from table; |