Postgresql issue: FATAL: dsa_allocate could not find 7 free pages

Hello,

I’m facing an issue on a particular query.

I’m getting this error:

Some users have faced this issue which seems to be a bug in postgresql query planner which should be solved :

But I’m still facing this issue.

I’m using postgresql 10.5 on ubuntu 18.04 

With timescaledb extension (which could be involved in this bug but I couldn’t find any related issue on their side)

This could be related to the number of parallel Bitmap Heat scan. If I reduce the amount of data to analyze, the query works.

One work around is to disable parraller workers with:

set max_parallel_workers_per_gather to 0;

With that changes, the query works as expected and I’ve got this query plan :

I’ve attached the failing query plan and working query plan (with max_parallel_workers_per_gather set to 0)

Thanks for your help