Date: Fri, 16 Mar 2007 10:44:04 -0700
From: David Fetter <david@fetter.org>
To: Reece Hart <reece@harts.net>
Cc: Robert Treat <xzilla@users.sourceforge.net>, pgsql-general@postgresql.org,
	"Jonah H. Harris" <jonah.harris@gmail.com>,
	Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
Subject: Re: [SQL] PostgreSQL to Oracle
Message-ID: <20070316174404.GC8169@fetter.org>
References: <55c095e90703090954m74e2b06arf73e3037f25f5c18@mail.gmail.com>
	<36e682920703091032u22cd9901w6212c9aba999ec8c@mail.gmail.com>
	<200703151620.34309.xzilla@users.sourceforge.net>
	<1174065536.5244.22.camel@snafu.site>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <1174065536.5244.22.camel@snafu.site>
User-Agent: Mutt/1.4.2.2i

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