current community

your communities

more stack exchange communities

Stack Exchange
tour help
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.
up vote 2 down vote favorite

I have 2 SDE instances.

  • Both have the same amount of data (2000 datasets both raster and vector).

  • One is PostGreSQL 9.2 with ArcSDE 10.2.1

  • One is Oracle 11g with ArcSDE 10.2.1

So basically the only difference is the RDBMS. The oracle instance takes 5 seconds to open in ArcCatalog. The PostGreSQL instance takes 26 seconds to open in ArcCatalog.

Does anyone know why this is happening and how we can get PostGreSQL instance to open just as fast as the Oracle one.

share|improve this question
    
related Tune Postgres stackoverflow.com/questions/9407442/… –  Mapperz♦ Mar 10 at 14:54
    
Tried most of that @Mapperz –  Vidar Mar 10 at 16:12

1 Answer 1

up vote 1 down vote

1) Are the two databases running on similar hardware?

2) Have you tuned the Postgres server? By default Postgres is configured to run using minimal resources. That's good because you won't swamp your server just by setting it up, but it handicaps Postgres when you start to try to do real work. As a start here are two links to the Postgres Wiki to get you started on which settings can be tweaked for better performance:

https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server

http://wiki.postgresql.org/wiki/Performance_Optimization

share|improve this answer
    
You work up some initial, quick & dirty config values here: pgtune.leopard.in.ua –  Jay Cummins Mar 10 at 15:38
    
Each database runs on it's own seperate VM (HyperV). –  Vidar Mar 10 at 16:13

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.