Tuning PostgreSQL for production use - rbeckman-nextgen/test-mc GitHub Wiki
Created by Jacob Brauer, last modified by Gerald Bortis on Nov 01, 2010
We recommend PostgreSQL as the back-end database for production use of Mirth Connect (we use it on our appliances). Make sure you add the following lines to your configuration file:
autovacuum=on
autovacuum_vacuum_threshold=1000
This ensures that the database stays speedy, especially with a large number of messages.
Here are a few hints for tuning PostgreSQL further:
- A nice overview and possibly some decent hints:http://revsys.com/writings/postgresql-performance.html
- And of course the pgsql-performance mailing lists: http://archives.postgresql.org/pgsql-performance/
Document generated by Confluence on Nov 11, 2019 08:40