|
Home > Archive > PostgreSQL Discussion > January 2006 > question about large databases
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
question about large databases
|
|
| Sergey Karin 2006-01-27, 7:23 am |
| Hi, List!
Some times ago in this list was discussed next question: Which databases are
small and which are large?
The answer was:
1-2 GB - small
50 and around - large
As I think, hundreds of GB and more - very large (VLDB).
How Postgres works with VLDB? And what about speed? Can I expect that
postgres works with VLDB not worse that commertial DBMS (DB2, Oracle,
Informix). Maybe someone have a comparision results of Postgres, DB2, Oracle
and Informix (or postgres and any of commertial DBMS) when this DBMS manage
with VLDB? I will VERY, VERY respect to that man for the information...
My organisation plans to use GIS based on PostGIS/Postgres. As we think,
size of our database can be 50, 100 and more Gb.
Thanks in advance!
Sergey Karin
| |
| Richard Huxton 2006-01-27, 7:23 am |
| Sergey Karin wrote:
> Maybe someone have a comparision results of Postgres, DB2, Oracle
> and Informix (or postgres and any of commertial DBMS) when this DBMS manage
> with VLDB? I will VERY, VERY respect to that man for the information...
It is against the rules of your Oracle licence to publish performance
comparisons with other databases. The same with most other commercial RDBMS.
If you can provide more details about your setup, someone else might
have experience to share though.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
|
|
|
|
|