Date: Mon, 26 Nov 2018 15:45:09 -0300
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Jakub Glapa <jakub.glapa@gmail.com>
Cc: pryzby@telsasoft.com, pgsql-performance@postgresql.org,
	Thomas Munro <thomas.munro@enterprisedb.com>
Subject: Re: dsa_allocate() faliure
Message-ID: <20181126184509.gge2vqmlu3twf72h@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CAJk1zg0GxWzkh1RESY0=RfoZ_20WaFyt2g7Me=cVr3VYngPthA@mail.gmail.com>
User-Agent: NeoMutt/20180716
Precedence: bulk

On 2018-Nov-26, Jakub Glapa wrote:

> Justin thanks for the information!
> I'm running Ubuntu 16.04.
> I'll try to prepare for the next crash.
> Couldn't find anything this time.

As I recall, the appport stuff in Ubuntu is terrible ... I've seen it
take 40 minutes to write the crash dump to disk, during which the
database was "down".  I don't know why it is so slow (it's a rather
silly python script that apparently processes the core dump one byte at
a time, and you can imagine that with a few gigabytes of shared memory
that takes a while).  Anyway my recommendation was to *remove* that
stuff from the server and make sure the core file is saved by normal
means.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services