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.
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 |