Re: BUG #14054: "create index using gist ..." on large table never completes. - Mailing list pgsql-bugs

From Emre Hasegeli
Subject Re: BUG #14054: "create index using gist ..." on large table never completes.
Date
Msg-id CAE2gYzzWjQdMgOKAMtMhgjODMPCWNcK-0LbJvTtSUjSxfB1oBw@mail.gmail.com
Whole thread Raw
In response to BUG #14054: "create index using gist ..." on large table never completes.  (tsingle@muddypaddock.com)
List pgsql-bugs
> Had previously tried same experiment with 9.2.3 on a Linux box where the 100
> million row table's index built within 5 hours.

It finished in an hour on my laptop for serially generated 100 million
rows.  I guess the regression is caused by too many overlapping
values.  GiST doesn't tend to perform well in this case.  I would give
SP-GiST a try.

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #13755: pgwin32_is_service not checking if SECURITY_SERVICE_SID is disabled
Next
From: cpacejo@clearskydata.com
Date:
Subject: BUG #14064: Sort order of bytea, etc. not defined