On Thu, Nov 03, 2011 at 03:19:36PM +0100, Alban Hertroys wrote:
> 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.
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/
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
