Hello,
My experience with dblink() is that each dblink() is executed serially, in
part I would guess, due to the plan for the query. To have each query run
in parallel you would need to execute both dblink()'s simultaneously saving
each result into a table. I'm not sure if the same table could
Spiegelberg, Greg wrote:
My experience with dblink() is that each dblink() is executed serially
Correct.
If you really want to do multiple queries simultaneously, you would need
to write a function very similar to dblink_record, but using asynchonous
libpq calls to both remote hosts. See: