Should pg 11 use a lot more memory building an spgist index?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Should pg 11 use a lot more memory building an spgist index?
Date: 2018-10-24 01:23:14
Message-ID: 20181024012314.GA27428@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

While reloading a database cluster to move from 10.5 to 11, I'm getting
out of memory crashes that I did see when doing reloads on pg 10.
The statement flagged in the log is this:
2018-10-23 16:44:34.815 CDT [126839] STATEMENT: ALTER TABLE ONLY public.iplocation
ADD CONSTRAINT overlap EXCLUDE USING spgist (network WITH &&);

iplocation has 4398722 rows.

This is geolite data where the networks are a partial covering of the total
address spaces with no overlaps.

Should I expect to have to make config changes to make this work?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2018-10-24 05:31:57 Re: Oracle vs PG
Previous Message Tim Cross 2018-10-24 00:32:00 Re: Oracle vs PG

Browse pgsql-hackers by date

  From Date Subject
Next Message Kyotaro HORIGUCHI 2018-10-24 03:02:45 Re: Optimze usage of immutable functions as relation
Previous Message Michael Paquier 2018-10-24 00:25:39 Unordered wait event ClogGroupUpdate