Thomas Munro <thomas.mu...@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.1492813...@sss.pgh.pa.us