Tue Jul 03, 2018 6:28 pm
There where a few versions of Resolve that had some issues with connection / loading time with postgresql dbs but not sure anymore which version.
Other the that it could be a networking issue, which you could check with a tool like iperf3. Large differences like that should be easily spotted if caused by net.
Other then that , make sure you have configured enough resources for the postgresql server. Check server logs and see if its not a configured resource bottleneck.
There are some opensource benchmark utilities that allow you to do performance tests against the postgresql db. But an average macmini can handle lots of clients with ease if configured properly.
Beatstep & APC-40 Resolve Edition Controllers https://posttools.tachyon-consulting.com
Test Rig : 2xXeon (24c) | UNRAID KVM OSX VM's | 128GB | 5700XT | 40Gbe
Prod Rig : i9-7940X (14c) | OSX 10.15 | 64GB | 2xVega 56 | 40Gbe | Tb3 | V:Eizo | A:5.1RME