Parallel query execution with SPI - Mailing list pgsql-hackers

From Konstantin Knizhnik
Subject Parallel query execution with SPI
Date
Msg-id 4a47030a-0787-d323-c231-09d656f9aba2@postgrespro.ru
Whole thread Raw
Responses Re: Parallel query execution with SPI  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Hi hackers,

It is possible to execute query concurrently using SPI?
If so, how it can be enforced?
I tried to open cursor with CURSOR_OPT_PARALLEL_OK flag but it doesn't 
help: query is executed by single backend while the same query been 
launched at top level uses parallel plan:
    fsstate->portal = SPI_cursor_open_with_args(NULL, fsstate->query, 
fsstate->numParams, argtypes, values, nulls, true, CURSOR_OPT_PARALLEL_OK);    ...    SPI_cursor_fetch(fsstate->portal,
true,1);
 

Thanks in advance,

-- 
Konstantin Knizhnik
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company




pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: Partitioned tables and relfilenode
Next
From: "Tsunakawa, Takayuki"
Date:
Subject: Re: Allow interrupts on waiting standby