Re: Shared memory error

From: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
To: Sonam Sharma <sonams1209(at)gmail(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Shared memory error
Date: 2020-06-04 11:42:00
Message-ID: CA+hUKGJ8pJAUADsu_ujDpZtQfsw4q+aQFtC4uj+M00TH0_VZiA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sonam Sharma 2020-06-04 13:00:18 Re: Shared memory error
Previous Message Praveen Kumar K S 2020-06-04 10:44:55 Re: Calculate hardware requirements