Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL 12.4 Parallel Query doesn't work while EXPLAIN is OK - Mailing list pgsql-general

From Tom Lane
Subject Re: PostgreSQL 12.4 Parallel Query doesn't work while EXPLAIN is OK
Date
Msg-id 1393711.1606834687@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostgreSQL 12.4 Parallel Query doesn't work while EXPLAIN is OK  (mobigroup <pechnikov@mobigroup.ru>)
Responses Re: PostgreSQL 12.4 Parallel Query doesn't work while EXPLAIN is OK  (mobigroup <pechnikov@mobigroup.ru>)
List pgsql-general
Tree view 
mobigroup <pechnikov@mobigroup.ru> writes:
>> Perhaps you didn't define it as PARALLEL SAFE.

> The function is marked as "PARALLEL RESTRICTED” because it’s uses temp tables (and I tested it as PARALLEL SAFE with
thesame result… parallelisation doesn’t work anyway). 

If it writes into temp tables then it can't be run in a worker anyway.

            regards, tom lane

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: error on connecting port 5432
Next
From: "Zwettler Markus (OIZ)"
Date:
Subject: FDW using remote ODBC driver