Re: [PERFORM] Trying to create multi db query in one large querie

2004-12-13 Thread Spiegelberg, Greg
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

Re: [PERFORM] Trying to create multi db query in one large querie

2004-12-13 Thread Joe Conway
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: