| From: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
|---|---|
| To: | CSN <cool_screen_name90001(at)yahoo(dot)com> |
| Cc: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL 8.1 vs. MySQL 5.0? |
| Date: | 2005-10-06 22:18:03 |
| Message-ID: | 20051006221802.GM36108@pervasive.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy pgsql-general |
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...
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2005-10-06 23:18:48 | 4th draft up -- get your comments in! |
| Previous Message | Jim C. Nasby | 2005-10-06 22:15:45 | Re: PostgreSQL 8.1 vs. MySQL 5.0? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-10-06 22:19:23 | Re: MS Access / Postgres ODBC / Outer joins |
| Previous Message | Jim C. Nasby | 2005-10-06 22:15:45 | Re: PostgreSQL 8.1 vs. MySQL 5.0? |