Page 1 of 1

2 of 3 Resolve Studio takes too long in connect to a Shared

PostPosted: Tue Jul 03, 2018 8:37 am
by Chemari
Hi all. We are using a shared postgresql 9.5.4 on a macmini. We have three resolve studio with 27 imac late 2015 and 10.12.6 , we are running resolve studio 14.1

One of the macs takes less than 15 seconds to connect to the shared database, the other two of them takes more than 10 mins to connect. Resolve studio start up too fast in local database for the three machines.

Any ideas?

Kindest regards

Re: 2 of 3 Resolve Studio takes too long in connect to a Sha

PostPosted: Tue Jul 03, 2018 6:28 pm
by Glenn Venghaus
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.

Re: 2 of 3 Resolve Studio takes too long in connect to a Sha

PostPosted: Wed Jul 04, 2018 9:39 am
by lithorus
If you are using a dns entry in the server address, try and switch to ip instead.
Helped on out systems.

- Jimmy

Re: 2 of 3 Resolve Studio takes too long in connect to a Sha

PostPosted: Wed Jul 04, 2018 9:43 am
by Chemari
We are using IP of postgre server.

Thank you!