Re: Oracle vs. PostgreSQL - a comment - Mailing list pgsql-general

From Stephen Frost
Subject Re: Oracle vs. PostgreSQL - a comment
Date
Msg-id 20200602212105.GC6680@tamriel.snowman.net
Whole thread Raw
In response to Re: Oracle vs. PostgreSQL - a comment  (Guyren Howe <guyren@gmail.com>)
List pgsql-general
Greetings,

* Guyren Howe (guyren@gmail.com) wrote:
> On Jun 2, 2020, at 14:16 , Stephen Frost <sfrost@snowman.net> wrote:
> > I'm sure there's things we can do to improve the performance of the FDW.
> > Not sure we'll get to a point where we are actually cacheing information
> > from the far side... but who knows, maybe if we arrange to have a
> > notification sent whenever certain objects are updated...
> >
> > These things could be worked on independnetly, of course, no need to
> > have one done before the other.
>
> By all means, let’s improve the FDW. But is it practical to make it possible to query across databases on the same
server, in a similar manner to SQL Server, without needing FDW at all? 

If you'd like to try and figure out how to make that work, it could be
theoretically possible, but I seriously doubt it'd be at all straight
forward to do, or that it'd ultimately end up being worth it.

Thanks,

Stephen

Attachment

pgsql-general by date:

Previous
From: Guyren Howe
Date:
Subject: Re: Oracle vs. PostgreSQL - a comment
Next
From: Stephen Frost
Date:
Subject: Re: Oracle vs. PostgreSQL - a comment