Re: PostgreSQL 8.1 vs. MySQL 5.0? - Mailing list pgsql-general

From Jim C. Nasby
Subject Re: PostgreSQL 8.1 vs. MySQL 5.0?
Date
Msg-id 20051006221802.GM36108@pervasive.com
Whole thread Raw
In response to Re: PostgreSQL 8.1 vs. MySQL 5.0?  (CSN <cool_screen_name90001@yahoo.com>)
Responses Re: PostgreSQL 8.1 vs. MySQL 5.0?
List pgsql-general
On Thu, Oct 06, 2005 at 12:40:49PM -0700, CSN wrote:
>
> --- Scott Marlowe <smarlowe@g2switchworks.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...
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: PostgreSQL Gotchas
Next
From: "Jim C. Nasby"
Date:
Subject: Re: PostgreSQL Gotchas