View Single Post

   
  #2 (permalink)  
Old 04-18-2008, 10:46 AM
Joe Conway
 
Posts: n/a
Default Re: Trying to create multi db query in one large querie

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:
http://www.postgresql.org/docs/curre...bpq-async.html

HTH,

Joe

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Reply With Quote