PGTune

Parameters of your system

PostgreSQL version (find out via 'SELECT version();')
Operation system of the PostgreSQL server host
For what type of application is PostgreSQL used
How much memory can PostgreSQL use
Number of CPUs, which PostgreSQL can use
CPUs = threads per core * cores per socket * sockets
Maximum number of PostgreSQL client connections
Type of data storage device

You need provide basic information about your hardware configuration, where is working PostgreSQL database. Results will be calculated after clicking "Generate" button

More information about "DB Type" setting:

  • Web Application (web)
    • Typically CPU-bound
    • DB much smaller than RAM
    • 90% or more simple queries
  • Online Transaction Processing (oltp)
    • Typically CPU- or I/O-bound
    • DB slightly larger than RAM to 1TB
    • 20-40% small data write queries
    • Some long transactions and complex read queries
  • Data Warehouse (dw)
    • Typically I/O- or RAM-bound
    • Large bulk loads of data
    • Large complex reporting queries
    • Also called "Decision Support" or "Business Intelligence"
  • Desktop application
    • Not a dedicated database
    • A general workstation, perhaps for a developer
  • Mixed type of application
    • Mixed DW and OLTP characteristics
    • A wide mixture of queries