On Sun, Feb 19, 2017 at 9:59 PM, Dilip Kumar <dilipbal...@gmail.com> wrote: > I can imagine it can get executed over and over if plan is something like > below. > > NestLoopJoin > -> SeqScan > -> Gather > -> Parallel Bitmap Heap Scan > > But in such case every time the Inner node of the NLJ will be > rescanned i.e. Gather will be rescanned which in turn shutdown > workers.
Yeah, but it looks like ExecReScanGather gets rid of the workers, but reuses the existing DSM. I'm not quite sure what happens to the DSA. It looks like it probably just hangs around from the previous iteration, which means that any allocations will also hang around. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers