DocsUser GuideConfiguration tuning

Configuration tuning

PostgreSQL has over 300 configuration parameters that can be tricky to set correctly. AutoDBA takes a data-driven approach to parameter tuning, using your workload to help you find the best settings.

  • What are the top 3 parameter tuning recommendations for this database?
  • I would like query SELECT... to run faster. Can system parameter tuning help?
  • I would like to optimize this system for latency and I’m willing to pay a little more for hardware. At what point do I hit diminishing returns?
  • What is the optimal setting for effective_cache_size for this workload and hardware configuration?
  • Would you recommend increasing the wal_buffers setting from its current value of 16MB to 32MB?
  • Are there any tables that would benefit from more frequent vacuuming?