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

My data generator is at https://github.com/flightlesson/mockdata.git

Here’s how I load 100 million rows:

createdb mockdb
mockdatagenerator --create-table --nrows 100000000 | psql mockdb

After loading the data

CREATE INDEX ON mock USING gist (handle,(int4range(range_low,range_high,’[]')));

seems to take forever.

Thanks,

tim

> On Apr 6, 2016, at 10:21 PM, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
>
> On Wed, Mar 30, 2016 at 1:38 AM, <tsingle(at)muddypaddock(dot)com> wrote:
>> The following bug has been logged on the website:
>>
>> Bug reference: 14054
>> Logged by: Tim Singletary
>> Email address: tsingle(at)muddypaddock(dot)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.
>
> "Randomly generated" covers a lot of territory and is not sufficient
> to be reproducible. Please provide the random generator.
>
> Thanks,
>
> Jeff