From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruno Wolff III <bruno@wolff.to>
cc: pgsql-general@lists.postgresql.org
Subject: Re: Should pg 11 use a lot more memory building an spgist index?
In-reply-to: <20181024012314.GA27428@wolff.to>
References: <20181024012314.GA27428@wolff.to>
Comments: In-reply-to Bruno Wolff III <bruno@wolff.to>
	message dated "Tue, 23 Oct 2018 20:23:14 -0500"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <19002.1540370027.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Wed, 24 Oct 2018 09:33:48 +0100
Message-ID: <19003.1540370028@sss.pgh.pa.us>
Precedence: bulk

Bruno Wolff III <bruno@wolff.to> writes:
> 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 &&);

Hm, there's a fair amount of new code in SP-GIST in v11, so maybe you've
hit a memory leak in that.  Can you create a self-contained test case?

			regards, tom lane