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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PostgreSQL 12.4 Parallel Query doesn't work while EXPLAIN is OK
Дата
Msg-id 1393711.1606834687@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: PostgreSQL 12.4 Parallel Query doesn't work while EXPLAIN is OK  (mobigroup <pechnikov@mobigroup.ru>)
Ответы Re: PostgreSQL 12.4 Parallel Query doesn't work while EXPLAIN is OK
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: error on connecting port 5432
Следующее
От: "Zwettler Markus (OIZ)"
Дата:
Сообщение: FDW using remote ODBC driver