Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Bruno Wolff III <bruno@xxxxxxxx> 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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux