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

From: Joe Conway <mail(at)joeconway(dot)com>
To: "Spiegelberg, Greg" <gspiegelberg(at)cranel(dot)com>
Cc: 'Hasnul Fadhly bin Hasan ' <hasnulfadhly(dot)h(at)mimos(dot)my>, "'pgsql-performance(at)postgresql(dot)org '" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Trying to create multi db query in one large querie
Date: 2004-12-14 06:59:37
Message-ID: 41BE8F59.9040707@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2004-12-14 07:18:24 Re: Trying to create multi db query in one large queries
Previous Message Bruno Wolff III 2004-12-14 05:22:50 Re: Similar tables, different indexes performance