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

Поиск
Список
Период
Сортировка
От tsingle@muddypaddock.com
Тема BUG #14054: "create index using gist ..." on large table never completes.
Дата
Msg-id 20160330083819.8934.34370@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #14054: "create index using gist ..." on large table never completes.  (Emre Hasegeli <emre@hasegeli.com>)
Re: BUG #14054: "create index using gist ..." on large table never completes.  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14054
Logged by:          Tim Singletary
Email address:      tsingle@muddypaddock.com
PostgreSQL version: 9.5.1
Operating system:   osx 10.11.4
Description:

"create index using gist ..." ran for over three days on 100 million row
table; completes within a couple hours on a 10 million row table.

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.

The table looks like

        CREATE TABLE mock (
            handle INT NOT NULL
            ,lowest INT NOT NULL
            ,highest INT NOT NULL
            ,stuff TEXT
        );

Data was randomly generated.

The command that never completes is:

create index on mock using gist (handle,(int4range(lowest,highest,'[]')));

В списке pgsql-bugs по дате отправления:

Предыдущее
От: maxim@jeslalabs.com
Дата:
Сообщение: BUG #14053: postgres crashes in plpgsql under load of concurrent transactions
Следующее
От: Marc-Olaf Jaschke
Дата:
Сообщение: Re: Missing rows with index scan when collation is not "C" (PostgreSQL 9.5)