pg.ddx.io  pgsql-general@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Bruno Wolff III <bruno@wolff.to>
To: pgsql-general@lists.postgresql.org
Subject: Re: Should pg 11 use a lot more memory building an spgist index?
Date: Wed, 24 Oct 2018 21:41:44 -0500
Message-ID: <20181025024144.GA17798@wolff.to> (raw)
In-Reply-To: <20181024012314.GA27428@wolff.to>
References: <20181024012314.GA27428@wolff.to>

On Tue, Oct 23, 2018 at 20:23:14 -0500,
  Bruno Wolff III <bruno@wolff.to> wrote:
>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.

I'm trying to reproduce this on my desktop but so far it isn't producing 
the same issue. The database is still loading after 9 hours, but it looks 
like it got past the point where the problem index was created. (I'm not 
sure how to check if the index has really finished being created, but \d 
shows it as existing.)

I'll know better tomorrow.

My workstation is using the Fedora version of postgresql 11 which might 
have some relevant difference from the pgdg version for rhel7. I still 
have a number of things I can try, but they might take significant time 
to run and I might not get a reasonable test case for a while.




view thread (24+ messages)  latest in thread

Message-ID: <20181025024144.GA17798@wolff.to>
Permalink:  ../20181025024144.GA17798@wolff.to/
Also on:    postgresql.org/message-id/20181025024144.GA17798@wolff.to

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-general@postgresql.org
  Cc: bruno@wolff.to, pgsql-general@lists.postgresql.org
  Subject: Re: Should pg 11 use a lot more memory building an spgist index?
  In-Reply-To: <20181025024144.GA17798@wolff.to>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox