Re: PostgreSQL 8.1 vs. MySQL 5.0?

On Thu, 2005-10-06 at 12:40 -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?

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/