We do have significant Asset Server installation with over 50GB of data.
Until recently there was no bigger issues, however lately we do observe really high IO of Unity PostgreSQL installation with constant over 1MB/s disk writes from PostgreSQL stats collector process. It is starting to cause IO issues for other services (such as SVN, git, etc.) that we host on same machine.
Do you have any ideas how to resolve this issue? I can provide some more debug information if needed.
We are using unity_asset_server-2.0.1f2-35557 compiled from source on Debian squeeze.
BTW: I’ve noticed that Unity PostgreSQL instance is configured to disable auto-vacuum. Maybe that is culprit, but i am weak with PostgreSQL administration and Unity Asset Server internals so i don’t want to muck the configuration.