Michael Paquier - PostgreSQL committer

  • Home
  • Manuals
  • Presentations
  • Projects
  • Resume
  • Tags
  • About

Home » manuals » postgresql » settings » planner

PostgreSQL - Planner

Here are a couple of tips for planner settings.

  • effective_io_concurrency, set to the number of I/O channels or ignore it
  • random_page_cost
  • 3.0 for a typical RAID10 array
  • 2.0 for a SAN
  • 1.1 for Amazon EBS

Search

Social

Github

RSS Feeds

Main

Postgres

Sponsor

Unless otherwise specified, the contents of this website are (C)Copyright Michael Paquier 2010-2025 and are licensed for use under CC BY-NC-ND 4.0.