Re: PostgreSQL 8.1 vs. MySQL 5.0?

On Thursday 06 October 2005 18:18, Jim C. Nasby wrote:
> On Thu, Oct 06, 2005 at 12:40:49PM -0700, CSN wrote:
> > --- Scott Marlowe <smarlowe(at)g2switchworks(dot)com> wrote:
> > > Federated Storage Engine: Allows MySQL to access
> > > tables in other
> > > servers like they are here. No real direct
> > > equivalent in PostgreSQL,
> > > but dblink provides similar functionality.
> >
> > Would that be possible with table partitions? Or
> > Slony?
>
> Slony would give you a loose approximation. Table partitioning is
> unrelated. Better yet, I don't know of any reason why you can't define a
> view using dblink that would duplicate the features of a federated
> system. Of course it would be easier if it was in the back-end...

You can, but if the view runs against a large table you're screwed since pg
can't optimize complex queries into the inital query to set up the view.

Not sure if my$ql is any smarter about this, but that's the first thing to
look for if you were to investigate how well it worked.

--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL