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

From Joshua D. Drake
Subject Re: PostgreSQL 8.1 vs. MySQL 5.0?
Date
Msg-id 1128635503.26307.1.camel@jd.commandprompt.com
Whole thread Raw
In response to Re: PostgreSQL 8.1 vs. MySQL 5.0?  (CSN <cool_screen_name90001@yahoo.com>)
List pgsql-general
On Thu, 2005-10-06 at 12:40 -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?

No. This is a actual cross database kind of thing. That is why
you need dblink. Table partitioning is same type of data multiple
tables.

Slony like Mammoth Replicator doesn't give you this either as we
just mirror (replicate) the data.

Sincerely,

Joshua D. Drake


>
> CSN
>
>
>
> __________________________________
> Yahoo! Mail - PC Magazine Editors' Choice 2005
> http://mail.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/



pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: PostgreSQL Gotchas
Next
From: "Dann Corbit"
Date:
Subject: Re: MS Access / Postgres ODBC / Outer joins