Re: Trying to create multi db query in one large querie - Mailing list pgsql-performance

From Joe Conway
Subject Re: Trying to create multi db query in one large querie
Date
Msg-id 41BE8F59.9040707@joeconway.com
Whole thread Raw
In response to Re: Trying to create multi db query in one large querie  ("Spiegelberg, Greg" <gspiegelberg@cranel.com>)
List pgsql-performance
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/current/static/libpq-async.html

HTH,

Joe

pgsql-performance by date:

Previous
From: "Spiegelberg, Greg"
Date:
Subject: Re: Trying to create multi db query in one large querie
Next
From: Josh Berkus
Date:
Subject: Re: Trying to create multi db query in one large queries