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

From Robert Haas
Subject Re: ERROR: too many dynamic shared memory segments
Date
Msg-id CA+TgmoYWDCbVDy7KYCUuXOWLjC2FqPmrcEZP3dn+K4AsL4DkHA@mail.gmail.com
Whole thread Raw
In response to Re: ERROR: too many dynamic shared memory segments  (Dilip Kumar <dilipbalaut@gmail.com>)
Responses Re: ERROR: too many dynamic shared memory segments
Re: ERROR: too many dynamic shared memory segments
List pgsql-general
On Tue, Nov 28, 2017 at 2:32 AM, Dilip Kumar <dilipbalaut@gmail.com> wrote:
>  I think BitmapHeapScan check whether dsa is valid or not if DSA is not
> valid then it should assume it's non-parallel plan.
>
> Attached patch should fix the issue.

So, create the pstate and then pretend we didn't?  Why not just avoid
creating it in the first place, like this?

I haven't checked whether this fixes the bug, but if it does, we can
avoid introducing an extra branch in BitmapHeapNext.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Attachment

pgsql-general by date:

Previous
From: Swapnil Vaze
Date:
Subject: vacuumdb fails with error pg_statistic_relid_att_inh_index constraintviolation after upgrade to 9.6
Next
From: Henrik Uggla
Date:
Subject: Refreshing materialized views