Re: dsa_allocate could not find 4 free pages

On Wed, Dec 6, 2017 at 6:17 AM, Mark Dilger <hornschnorter@gmail.com> wrote:
> I'm not asking for help configuring my system.  If this is a run of the mill out of memory
> type error, I'll deal with it myself.  But if this indicates a bug, I'll be happy to try to distill
> what I'm doing to a test case that I can share.  (I've only hit this once, and have little
> idea whether it would be reproducible.)  The gist of the query was an array_agg over
> the results of a parallel query over a partitioned table, executed from within a plpgsql
> function, like:
>
> SELECT ARRAY_AGG((a, latest, timelogged, b, cnt)::custom_composite_type) AS trans FROM
>     (SELECT a, b, timelogged, MAX(timelogged) OVER (PARTITION BY a) AS latest, SUM(cnt) AS cnt FROM
>         (SELECT a, b, timelogged, COUNT(*) AS cnt
>             FROM mytable
>             WHERE a= ANY('{65537,65538,65539,65540,65541,65542,65543,65544}'::OID[])
>             AND timelogged >= '2017-12-04 16:12:50-08'::TIMESTAMP
>             AND timelogged < '2017-12-04 17:12:50-08'::TIMESTAMP
>             GROUP BY a, b, timelogged
>         ) AS ss
>         GROUP BY a, b, timelogged
> ) AS s

Hi Mark,

Does the plan have multiple Gather nodes with Parallel Bitmap Heap Scan?

https://www.postgresql.org/message-id/flat/CAEepm%3D0Mv9BigJPpribGQhnHqVGYo2%2BkmzekGUVJJc9Y_ZVaYA%40mail.gmail.com

-- 
Thomas Munro
http://www.enterprisedb.com