From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>, CSN <cool_screen_name90001(at)yahoo(dot)com>, Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
Subject: | Re: PostgreSQL 8.1 vs. MySQL 5.0? |
Date: | 2005-10-07 15:21:01 |
Message-ID: | 200510071121.01696.xzilla@users.sourceforge.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | David Fetter | 2005-10-07 15:47:52 | Re: PostgreSQL 8.1 vs. MySQL 5.0? |
Previous Message | Robert Treat | 2005-10-07 14:45:06 | Re: PostgreSQL 8.1 vs. MySQL 5.0? |
From | Date | Subject | |
---|---|---|---|
Next Message | Emi Lu | 2005-10-07 15:26:08 | Looking for GUI for pg_dump/pg_restore under windows XP/2003 OS |
Previous Message | Robert Treat | 2005-10-07 14:59:16 | Re: PostgreSQL 8.1 vs. MySQL 5.0? |