Tuning a PostgreSQL database for IBM Business Automation Workflow

The topic applies to the usage of PostgreSQL by the Content Platform Engine when used with workload driven by the IBM Business Automation Workflow product. The guidance provided is based on simulations of the workload within the IBM software development labs.

Although suggested parameter settings are provided, it is expected that you consider the information and adjust the settings to fit your environment.

  • listen_addresses is required to accept connections from any IP
  • shared_buffers minimum 1024 MB recommended at least 25% of the memory
  • work_mem minimum 20 MB critical as used for sort operations
  • max_prepared_transactions e.g. 200 higher than max_connections
  • max_wal_size e.g. 6 MB
  • log_min_duration_statement e.g. 5000
  • temp_buffers e.g. 512MB
  • max_connections e.g. 200