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.