Обсуждение: PostgreSQL as a DDBMS

Поиск
Список
Период
Сортировка

PostgreSQL as a DDBMS

От
Rodrigo Bonfa
Дата:
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
Дата:
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"
Дата:
If your looking to have users connect to one database & see the entire enterprise worth of databases then Postgres is
notwhat 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