Postgres Pro
Downloads
Home   >   mailing lists

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

From mobigroup
Subject Re: PostgreSQL 12.4 Parallel Query doesn't work while EXPLAIN is OK
Date
Msg-id B998E756-A157-4D8E-AC1E-88A56FDAF5F3@mobigroup.ru
Whole thread Raw
In response to Re: PostgreSQL 12.4 Parallel Query doesn't work while EXPLAIN is OK  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
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@sss.pgh.pa.us> wrote:

PARALLEL RESTRICTED

pgsql-general by date:

Previous
From: Hemil Ruparel
Date:
Subject: Re: FDW using remote ODBC driver
Next
From: "Zwettler Markus (OIZ)"
Date:
Subject: AW: FDW using remote ODBC driver