we are working on one big layer at the same time (10-20 people). Some of us use QGIS 2.8.1 and the other 2.6. The user with 2.8 have a lot of crashes (QGIS). The 2.6 users don't have this crashes but to add a feature is incredible slow. The Postgres 9.4 server is running on a Virtual Machine (Hyper V) with Win7. Maybe it's the network and not QGIS? Maybe someone have an idea. Would be great :)
Below the answers posted in the comments :
(@Mapperz) HyperV might need more RAM memory : See Microsoft technet article (Hyper-V Overhead). Try increasing to 16GB
(@ndawson) Try to upgrade QGIS on the lastest versions
(@Michael Stimson) PostGIS does perform better on Linux, but if possible, get it running on it's on workstation (server) rather than a virtual machine. Have also a look for questions regarding the performance of PostgreSQL and tuning on Database Administrators Stack Exchange. If everyone connect with the same login the tablespace can get a little cluttered and lots of objects juggling around. It is not the best but will still work. I think the best thing is to put it on its own computer (not VM) and have the data on SSD/RAID.
(@RustProof Labs) RAM, disk speed, processor load and network speed could all affect performance, it's hard to say without having monitoring in place to see where the bottleneck is. One thing I have had success with is increasing the cache sizes in QGIS to allow the individual machines to store more locally and reduce load on the server. I think the defaults were around 50MB, I've upped mine more to the 200 MB range with good results.
(@Luigi Pirelli) You should follow these steps to understand if there is a Postgres provider bug or local installation issue:
- A) test with qgis on different platforms, win, linux, mac
- B) look for a replicable crash
- C) Always share the error or log
- D) Check with dev version to have log enabled....