Re: ERROR: too many dynamic shared memory segments

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: ERROR: too many dynamic shared memory segments
Дата
Msg-id CA+TgmoYWDCbVDy7KYCUuXOWLjC2FqPmrcEZP3dn+K4AsL4DkHA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ERROR: too many dynamic shared memory segments  (Dilip Kumar <dilipbalaut@gmail.com>)
Ответы Re: ERROR: too many dynamic shared memory segments
Re: ERROR: too many dynamic shared memory segments
Список 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

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Swapnil Vaze
Дата:
Сообщение: vacuumdb fails with error pg_statistic_relid_att_inh_index constraintviolation after upgrade to 9.6
Следующее
От: Henrik Uggla
Дата:
Сообщение: Refreshing materialized views