Skip site navigation (1) Skip section navigation (2)

Automatic tuning of postgresql.conf parameters?

From: "Mattias Kregert" <mattias(at)kregert(dot)se>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Automatic tuning of postgresql.conf parameters?
Date: 2006-03-30 09:16:34
Message-ID: 00b201c653da$a4409670$09000a0a@kregert.se (view raw or flat)
Thread:
Lists: pgsql-performance
I have noticed that a lot of people have a hard time finding out how to tune postgresql to suit their hardware.

Are there any tools for automatic tuning of the parameters in postgresql.conf? A simple program running some benchmarks on cpu & disk speed, checking the amount of ram and so on and then suggesting random/seq access cost, vacuum cust, sortmem/cache settings and so on? A pg_tune utility?

Maybe it could even look at runtime statistics/usage logs and help set the number of shared buffers, chekpoints, autovacuum...?

/Mattias (using the default config)

pgsql-performance by date

Next:From: Peter EisentrautDate: 2006-03-30 11:59:10
Subject: Index scan startup time
Previous:From: Markus SchaberDate: 2006-03-30 08:29:51
Subject: Re: Decide between Postgresql and Mysql (help of

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group