Re: dsa_allocate() faliure - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: dsa_allocate() faliure
Date
Msg-id 20181126184509.gge2vqmlu3twf72h@alvherre.pgsql
Whole thread Raw
In response to Re: dsa_allocate() faliure  (Jakub Glapa <jakub.glapa@gmail.com>)
List pgsql-performance
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


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: autovacuum run but last_autovacuum is empty
Next
From: Sanyo Moura
Date:
Subject: Query with high planning time at version 11.1 compared versions 10.5and 11.0