Postgres Pro
Downloads
Home   >   mailing lists

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

From Thomas Munro
Subject Re: ERROR: too many dynamic shared memory segments
Date
Msg-id CA+hUKGLyxv6+5WeMcg3+UC2HX4rtoWGzgnsx+Sfv++MJwEi-WQ@mail.gmail.com
Whole thread Raw
In response to Re: ERROR: too many dynamic shared memory segments  (Nicola Contu <nicola.contu@gmail.com>)
Responses Re: ERROR: too many dynamic shared memory segments  ("dainius.b" <dainius.bratkauskas@gmail.com>)
List pgsql-general
Tree view 
On Fri, Jan 31, 2020 at 11:05 PM Nicola Contu <nicola.contu@gmail.com> wrote:
> Do you still recommend to increase max_conn?

Yes, as a workaround of last resort.  The best thing would be to
figure out why you are hitting the segment limit, and see if there is
something we could tune to fix that. If you EXPLAIN your queries, do
you see plans that have a lot of "Gather" nodes in them, perhaps
involving many partitions?  Or are you running a lot of parallel
queries at the same time?  Or are you running queries that do very,
very large parallel hash joins?  Or something else?

pgsql-general by date:

Previous
From: Thomas Munro
Date:
Subject: Re: ERROR: too many dynamic shared memory segments
Next
From: "Peter J. Holzer"
Date:
Subject: Re: Need support on tuning at the time of index creation