Skip to main content
Database Administrators

Return to Answer

Updated description
Source Link
Paul Bellora
Paul Bellora
  • 301
  • 1
  • 6

Consider using pgtunePGTune to help you tune the PostgreSQL configuration. From PgFoundry:

pgtune takes the wimpy default postgresql.conf and expands the database server to be as powerful as the hardware it's being deployed on

PostgreSQL's default configuration is very conservative and that tool is meant to help with this exact situation. The documentation is a light read and using the tool is pretty straightforward.

Keep in mind that there's no need to use pgtune'sPGTune's exact suggestions. Playing with its settings and watching the resulting changes to the conf file will give you a better understanding of PostgreSQL's configuration and how to tweak it manually.

More info on PGTune and an alternative tool called ClusterControl: PGTune Alternatives - ClusterControl PostgreSQL Configuration

Consider using pgtune to help you tune the PostgreSQL configuration. From PgFoundry:

pgtune takes the wimpy default postgresql.conf and expands the database server to be as powerful as the hardware it's being deployed on

PostgreSQL's default configuration is very conservative and that tool is meant to help with this exact situation. The documentation is a light read and using the tool is pretty straightforward.

Keep in mind that there's no need to use pgtune's exact suggestions. Playing with its settings and watching the resulting changes to the conf file will give you a better understanding of PostgreSQL's configuration and how to tweak it manually.

Consider using PGTune to help you tune the PostgreSQL configuration.

PostgreSQL's default configuration is very conservative and that tool is meant to help with this exact situation. The documentation is a light read and using the tool is pretty straightforward.

Keep in mind that there's no need to use PGTune's exact suggestions. Playing with its settings and watching the resulting changes to the conf file will give you a better understanding of PostgreSQL's configuration and how to tweak it manually.

More info on PGTune and an alternative tool called ClusterControl: PGTune Alternatives - ClusterControl PostgreSQL Configuration

Post Migrated Here from stackoverflow.com (revisions)
Source Link
Paul Bellora
Paul Bellora
  • 301
  • 1
  • 6

Consider using pgtune to help you tune the PostgreSQL configuration. From PgFoundry:

pgtune takes the wimpy default postgresql.conf and expands the database server to be as powerful as the hardware it's being deployed on

PostgreSQL's default configuration is very conservative and that tool is meant to help with this exact situation. The documentation is a light read and using the tool is pretty straightforward.

Keep in mind that there's no need to use pgtune's exact suggestions. Playing with its settings and watching the resulting changes to the conf file will give you a better understanding of PostgreSQL's configuration and how to tweak it manually.