Thread: question about large databases
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
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
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