7

I have searched on google and the archives for a technical comparison of Oracle and PostgreSQL (also MySQL), unsuccessfully.

Is there any comparison that covers more than just the basic differences? Maybe you can give me some comparison?

Improve this question
7
  • 2
    Database comparisons has already been discussed into that thread : gis.stackexchange.com/questions/7818/… You will probably get interesting stuff there. – simo Apr 13 '11 at 7:31
  • I want something more complex (like underdark), anyway thanks – com Apr 13 '11 at 7:34
  • underdark's link is provided in the first answer. And you will get more reading others replies! – simo Apr 13 '11 at 7:36
  • 2
    Non technical comment: PostGIS is already being used for serious work. For instance, the Institut Géographique National of France decided to use PostGIS after benchmarking it and propietary solutions like Oracle or DB2. More information about it can be found at postgis.refractions.net/documentation/casestudies/ign. – dariapra Apr 13 '11 at 10:43
  • 2
    As this question is stated, this is off-topic and should be asked on DBA.stackexchange.com instead. – Jonas Apr 14 '11 at 6:48
4

Thesis by Shamal Kiran Matty (2012) 'Comparative study of Oracle Spatial and Postgres Spatial' discusses quite a lot of issues that might be of interest here.

From the summary:

However, the research done as a part of this thesis suggests that PostGIS is more advantageous over Oracle Spatial for the reasons stated below:

  1. Cost Savings
  2. Ease of Integration
  3. Ease of use
  4. Superior performance
  5. Feature rich
  6. Lower disk usage

(via @FaunaliaGIS)

Improve this answer
0
11

Check BostonGIS Compare SQL Server 2008 R2, Oracle 11G R2, PostgreSQL/PostGIS 1.5 Spatial Features. If that's too basic: Which topics do you need covered?

MySQL is not usable for serious GIS work.

Improve this answer
3
  • 5
    Wow, a SQL Server enterprise licence starts at $29000 for a single processor! Thanks good for PostgreSQL running queries with my 4 processors at $0 cost. – Pablo Apr 13 '11 at 14:46
  • 4
    postgres every time... always the bottom line. – Mapperz♦ Apr 13 '11 at 14:52
  • @pablo - the enterprise licence is more for deploying large data farms. The standard edition is a more suitable comparison. – geographika Jul 24 '11 at 10:42
1

In the meantime I had found the following Comparison of Oracle, MySQL and PostgreSQL DBMS which i think is a good overview.

Improve this answer
2
  • 3
    Be aware that this comparison is "very" old (2005). – underdark♦ Apr 13 '11 at 14:38
  • You're right! I don't pay attention to that. Thanks to point it. Anyway is good :) – com Apr 13 '11 at 14:58

Not the answer you're looking for? Browse other questions tagged or ask your own question.