Re: PostgreSQL 12.4 Parallel Query doesn't work while EXPLAIN is OK

From: mobigroup <pechnikov(at)mobigroup(dot)ru>
To:
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: PostgreSQL 12.4 Parallel Query doesn't work while EXPLAIN is OK
Date: 2020-12-01 15:10:28
Message-ID: B998E756-A157-4D8E-AC1E-88A56FDAF5F3@mobigroup.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom,

Ok, but how about reading from temporary tables? We could mark the function as "PARALLEL SAFE” instead of "PARALLEL RESTRICTED” in this case if it’s important. Actually, I rewrote the function without temp tables access but that’s not helpful - the function marked as "PARALLEL SAFE” is not parallel even without temp tables access.

—
Best regards, Alexey Pechnikov

> On 1 Dec 2020, at 21:58, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
>> PARALLEL RESTRICTED

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Zwettler Markus (OIZ) 2020-12-01 15:13:30 AW: FDW using remote ODBC driver
Previous Message Hemil Ruparel 2020-12-01 15:07:46 Re: FDW using remote ODBC driver