Re: Shared memory error - Mailing list pgsql-general

From Thomas Munro
Subject Re: Shared memory error
Date
Msg-id CA+hUKGJ8pJAUADsu_ujDpZtQfsw4q+aQFtC4uj+M00TH0_VZiA@mail.gmail.com
Whole thread Raw
In response to Re: Shared memory error  (Thomas Munro <thomas.munro@gmail.com>)
Responses Re: Shared memory error  (Sonam Sharma <sonams1209@gmail.com>)
List pgsql-general
>> Do you see any other errors around this one, in the PostgreSQL logs?
> No , only this is the error from db and jdbc end .. and queries are failing

If you need a workaround right now you could always set
max_parallel_workers_per_gather=0 so that it doesn't try to use
parallel query.  That could make some queries run more slowly.

When you say you extended the /dev/shm filesystem, what are the mount
options, or how did you configure it?  It's interesting that the
problem went away for a while when you did that.



pgsql-general by date:

Previous
From: Praveen Kumar K S
Date:
Subject: Re: Calculate hardware requirements
Next
From: Sonam Sharma
Date:
Subject: Re: Shared memory error