Mapping and Charting Enterprise Databases

By Jonathan Murphy
Let’s crack the lid on ArcGIS Pro 3.5 and take a peek at what the Geodatabase Team has put in there. I’ll give a high-level overview of the main features we’ve added, and we can dig deeper into the details of some of these things in future posts.

It is essential to ensure that your Cloud PostgreSQL instances and PostGIS extension are patched with the latest updates to maintain optimal performance and security.

Workflows have been identified that can cause inconsistencies in the branch versioning system tables. When such an issue is encountered, features with missing branch versioning metadata can cause data inconsistencies when the version is reconciled, posted, and/or deleted.

Oracle Enterprise Geodatabase SDE Repository Upgrade using an Oracle Restore Point to Rollback the changes in case of problems.

WMX attachments table "JTX_JOB_ATTACHMENTS" can grow very large.
The best practice is to move the table to its own filegroup / tablespace / datafile
to reduce fragmentation and contention, and to improve performance.

How to Move and Upgrade a WMX Repository Enterprise GDB

Egdbhealth is a tool for reporting on various characteristics of Enterprise Geodatabases (eGDBes). 

Mapping & Charting Solutions (MCS) Enterprise Databases Best Practices

Intended for database administrators as recommendations for establishing the product workspaces in an Enterprise Geodatabase (Oracle®, SQL Server®, PostgreSQL®).