From: | David Fetter <david(at)fetter(dot)org> |
---|---|
To: | Reece Hart <reece(at)harts(dot)net> |
Cc: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, pgsql-general(at)postgresql(dot)org, "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>, Ezequias Rodrigues da Rocha <ezequias(dot)rocha(at)gmail(dot)com> |
Subject: | Re: [SQL] PostgreSQL to Oracle |
Date: | 2007-03-16 17:44:04 |
Message-ID: | 20070316174404.GC8169@fetter.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
On Fri, Mar 16, 2007 at 10:18:56AM -0700, Reece Hart wrote:
> On Thu, 2007-03-15 at 16:20 -0400, Robert Treat wrote:
> > Do you find [HSODBC] works well? I've used it from some older
> > Oracle instances connecting back into PostgreSQL and the results I
> > had have been flakey at best.
>
> - The real nail in the coffin seemed to be that there was no way to
> push predicates to the remote side. This mean that a remote relation
> was materialized locally in order to join with local data and that
> we'd never get reasonable performance for cross-database joins
> (which, perhaps, it's not designed to do).
DBI-Link has a way to push predicates to the remote side, but you have
to do it manually because DBI-Link is a user-space application, i.e.
it doesn't have access to PostgreSQL's planner.
Let me know if you have questions on how this works :)
Cheers,
D
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter
Remember to vote!
Consider donating to PostgreSQL: http://www.postgresql.org/about/donate
From | Date | Subject | |
---|---|---|---|
Next Message | Stefan Berglund | 2007-03-16 17:57:48 | Re: Is This A Set Based Solution? |
Previous Message | Reece Hart | 2007-03-16 17:18:56 | Re: [SQL] PostgreSQL to Oracle |
From | Date | Subject | |
---|---|---|---|
Next Message | Jonah H. Harris | 2007-03-16 18:20:35 | Re: [SQL] PostgreSQL to Oracle |
Previous Message | Reece Hart | 2007-03-16 17:18:56 | Re: [SQL] PostgreSQL to Oracle |