pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL as a DDBMS
3+ messages / 3 participants
[nested] [flat]
* PostgreSQL as a DDBMS
@ 2004-08-18 13:30 Rodrigo Bonfa <bonfa@inf.ufes.br>
2004-08-20 11:03 ` Re: PostgreSQL as a DDBMS Gaetano Mendola <mendola@bigfoot.com>
0 siblings, 1 reply; 3+ messages in thread
From: Rodrigo Bonfa @ 2004-08-18 13:30 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: PostgreSQL as a DDBMS
2004-08-18 13:30 PostgreSQL as a DDBMS Rodrigo Bonfa <bonfa@inf.ufes.br>
@ 2004-08-20 11:03 ` Gaetano Mendola <mendola@bigfoot.com>
0 siblings, 0 replies; 3+ messages in thread
From: Gaetano Mendola @ 2004-08-20 11:03 UTC (permalink / raw)
To: Rodrigo Bonfa <bonfa@inf.ufes.br>
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: PostgreSQL as a DDBMS
@ 2004-08-20 14:09 Goulet, Dick <DGoulet@vicr.com>
0 siblings, 0 replies; 3+ messages in thread
From: Goulet, Dick @ 2004-08-20 14:09 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-08-20 14:09 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-08-18 13:30 PostgreSQL as a DDBMS Rodrigo Bonfa <bonfa@inf.ufes.br>
2004-08-20 11:03 ` Gaetano Mendola <mendola@bigfoot.com>
2004-08-20 14:09 Re: PostgreSQL as a DDBMS Goulet, Dick <DGoulet@vicr.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox