Re: ERROR: too many dynamic shared memory segments - Mailing list pgsql-general

From Tom Lane
Subject Re: ERROR: too many dynamic shared memory segments
Date
Msg-id 14346.1511810185@sss.pgh.pa.us
Whole thread Raw
In response to Re: ERROR: too many dynamic shared memory segments  (Thomas Munro <thomas.munro@enterprisedb.com>)
List pgsql-general
Thomas Munro <thomas.munro@enterprisedb.com> writes:
> Ah, so you have many Gather nodes under Append?  That's one way to eat
> arbitrarily many DSM slots.  We allow for 64 + 2 * max_backends.  Does
> it help if you increase max_connections?  I am concerned about the
> crash failure mode you mentioned in the first email though: we should
> always be able to handle that condition gracefully.

I suspect this is an instance of the issue I complained about before [1]
that parallel query is unable to cope with worker start failure.
        regards, tom lane

[1] https://www.postgresql.org/message-id/4905.1492813727@sss.pgh.pa.us


pgsql-general by date:

Previous
From: Robert Lakes
Date:
Subject: Setting a default for nextval sequence
Next
From: "David G. Johnston"
Date:
Subject: Re: Setting a default for nextval sequence