Hey everyone,
Quick question — how slow is too slow when using ArcGIS Enterprise with a PostgreSQL backend?
Here’s what I’ve got going on:
I’m referencing my data directly from a PostgreSQL database — I’m not copying it to the ArcGIS Data Store. I’ve uploaded a short video below to show what I mean. The feature class shown is only 68 MB, so it’s not huge by any means, but as you’ll see, performance feels pretty sluggish.
Also, for context:
I’ll include full specs of our Enterprise environment (Portal, Server, PostgreSQL, etc.)
I’ll also include the specs of my local machine, just in case the issue is on my end
It’s not just the portal either. Even inside ArcGIS Pro, using a direct .sde connection to that same PostgreSQL server, everything feels painfully slow. Just as an example:
I deleted a 6 KB table from within Pro that was stored in the PostgreSQL server, and it took three and a half minutes to complete. 😬
So yeah — just wondering, is this normal? Or should I start digging into tuning or configuration changes?
I have attached a video of me using the portal with the above described feature class being on the PostgreSQL server.
Thanks a ton in advance for any insights!
Finally, this is a brand-new Enterprise setup with a fresh PostgreSQL server, it’s the only workload on that box, and I’m the only user connected right now. I'm all alone and so is it, and this is the speeds I get.
Also my ping speed to the server:
