Postgresql tuning for external db

Hello.



We are going to be moving to an external postgresql cluster that will be shared between our production appliances (VMs).



Our dba wanted to know if there are any settings in either config file (pg_hba.conf, postgresql.conf) that Mirth requires or wants to operate efficiently.



I found a couple of posts that had some settings for autovacuum (autovacuum=on and autovacuum_vacuum_threshold=1000) but wanted to check to see if there are any others.



Any pointers you might have about Mirth specific settings would be muchly appreciated.



Thanks,



Bruce McGuire

Northern Health Authority

Prince George, BC

Canada

Postgresql tuning for external db