Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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?

share|improve this question
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
1  
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
show 2 more comments

3 Answers

up vote 4 down vote accepted

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)

share|improve this answer
1  
That it what i was looking for. Thanks! –  com May 3 '12 at 21:08
add comment

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

share|improve this answer
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
add comment

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.

share|improve this answer
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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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