| 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: | Whole Thread | Raw Message | 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?
| 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 |
| 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 |