PostgreSQL as a DDBMS
PostgreSQL as a DDBMS
От:
Rodrigo Bonfa <bonfa@inf.ufes.br>
Дата:
Friends, I would like to know if PostgreSQL can run as a Distributed Data Base Management System. Is possible, throught PostgreSQL, to implement horizontal partition, this is, to fragment tables horizontally? For example, can I have a Data Base with 1 table, where it is horizontally fragmented and each fragment is located on different places (postgresql servers)? See that the Data Base is Unique, but the Data are distributed throught a horizontal partitioning. How PostgreSQL could help me to solve this problem? Thanks, Rodrigo.
Re: PostgreSQL as a DDBMS
От:
Gaetano Mendola <mendola@bigfoot.com>
Дата:
Rodrigo Bonfa wrote: > Friends, > I would like to know if PostgreSQL can run as a Distributed Data Base > Management System. Is possible, throught PostgreSQL, to implement > horizontal partition, this is, to fragment tables horizontally? > For example, can I have a Data Base with 1 table, where it is > horizontally fragmented and each fragment is located on different places > (postgresql servers)? See that the Data Base is Unique, but the Data are > distributed throught a horizontal partitioning. How PostgreSQL could > help me to solve this problem? In one word: no. Regards Gaetano Mendola
Re: PostgreSQL as a DDBMS
От:
"Goulet, Dick" <DGoulet@vicr.com>
Дата:
If your looking to have users connect to one database & see the entire enterprise worth of databases then Postgres is not what you want. Have damanagement get out their wallet & buy Oracle instead. It's made to purpose.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Rodrigo Bonfa [mailto:bonfa@inf.ufes.br]
Sent: Wednesday, August 18, 2004 9:30 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] PostgreSQL as a DDBMS
Friends,
I would like to know if PostgreSQL can run as a Distributed Data Base
Management System. Is possible, throught PostgreSQL, to implement
horizontal partition, this is, to fragment tables horizontally?
For example, can I have a Data Base with 1 table, where it is
horizontally fragmented and each fragment is located on different places
(postgresql servers)? See that the Data Base is Unique, but the Data are
distributed throught a horizontal partitioning. How PostgreSQL could
help me to solve this problem?
Thanks,
Rodrigo.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly