From: David Fetter <david@fetter.org>
To: Reece Hart <reece@harts.net>
Cc: Robert Treat <xzilla@users.sourceforge.net>
Cc: pgsql-general@postgresql.org, "Jonah H. Harris" <jonah.harris@gmail.com>
Cc: Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
Subject: Re: [SQL] PostgreSQL to Oracle
Date: Fri, 16 Mar 2007 10:44:04 -0700
Message-ID: <20070316174404.GC8169@fetter.org> (raw)
In-Reply-To: <1174065536.5244.22.camel@snafu.site>
References: <55c095e90703090954m74e2b06arf73e3037f25f5c18@mail.gmail.com>
<36e682920703091032u22cd9901w6212c9aba999ec8c@mail.gmail.com>
<200703151620.34309.xzilla@users.sourceforge.net>
<1174065536.5244.22.camel@snafu.site>
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@fetter.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: david@fetter.org, reece@harts.net, xzilla@users.sourceforge.net, jonah.harris@gmail.com, ezequias.rocha@gmail.com
Subject: Re: [SQL] PostgreSQL to Oracle
In-Reply-To: <20070316174404.GC8169@fetter.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox