Set Returning Function (Pipelining)
Hi everyone,
I have a question on set returning functions. In one of the TechDocs on
the postgres website it says:
"Currently SRF returning PL/pgSQL functions must generate the entire
set before the result is returned"
It also says that this might be changed in future releases (later than
7.3).
My question is now wether the result is returned linewise in an newer
version and if yes, wether a program using the
S(erver)P(rogramming)I(interface) can utilize this functionality in
order get a better distribution of the workload?
Thx for your help,
tschak
tschak wrote:
I have a question on set returning functions. In one of the TechDocs on
the postgres website it says:
"Currently SRF returning PL/pgSQL functions must generate the entire
set before the result is returned"It also says that this might be changed in future releases (later than
7.3).
My question is now wether the result is returned linewise in an newer
version
I'm afraid not. But are you sure you need pipelining?
Joe
I am not really sure wether I MUST use it or not, but I think it is a
nice feature to be utilized.
What I want is a long running producing up to hundred of thousands
results which have to undergo a computationally expensive
postprocessing step which needs to be execeuted in parallel. By using
pipelining I would not need to worry about partitioning the query and
thus distributing the workload.
At least as far as I understand the pipelining feature...
tschak