Re: BUG #14054: "create index using gist ..." on large table never completes.

Поиск
Список
Период
Сортировка
От Emre Hasegeli
Тема Re: BUG #14054: "create index using gist ..." on large table never completes.
Дата
Msg-id CAE2gYzzWjQdMgOKAMtMhgjODMPCWNcK-0LbJvTtSUjSxfB1oBw@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #14054: "create index using gist ..." on large table never completes.  (tsingle@muddypaddock.com)
Список 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 по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #13755: pgwin32_is_service not checking if SECURITY_SERVICE_SID is disabled
Следующее
От: cpacejo@clearskydata.com
Дата:
Сообщение: BUG #14064: Sort order of bytea, etc. not defined