dblink performance

From: "Alex Bible" <Alex(dot)Bible(at)ctg(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: dblink performance
Date: 2011-12-07 16:14:41
Message-ID: DA53AF8983A6F0468482CC52240A46F5021055B7@BUF-EX.ctg.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello All,

I'm currently on a development team utilizing PostgreSQL and we are
looking into the possibility of using dblink to reference an external
database (read only). Our system administrator and DBA were concerned
about the performance impact that cross-database queries would have on a
production application. Are there any known performance issues or
anything of the like that I would need to know before pushing this issue
further? I have been using PostgreSQL for the past couple months but
this is my first time using dblink. I really just need an opinion from
someone who has used this technology before. Thanks!

Alexander E. Bible

700 Delaware Ave.
Buffalo, NY 14226

Tel: (716)-888-3687
Mobile: (716)-472-9655
alex(dot)bible(at)ctg(dot)com

The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you are not the intended recipient of this
message, please contact the sender and delete this material from this computer.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message akp geek 2011-12-07 16:45:26 Fwd: postgres 9.0.4 Streaming related question ..
Previous Message Scott Marlowe 2011-12-07 15:47:14 Re: making "\pset pager off" the default