Re: Automagic tuning - Mailing list pgsql-performance

From Tom Lane
Subject Re: Automagic tuning
Date
Msg-id 3900.1107203172@sss.pgh.pa.us
Whole thread Raw
In response to Re: Automagic tuning  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Automagic tuning
List pgsql-performance
Josh Berkus <josh@agliodbs.com> writes:
>> I would like something that really measures values like random_page_cost
>> or cpu_tuple_cost that are hardware dependent.
>>
>> I assume such thing does not exist?

> Nope.  You gotta whip out your calculator and run some queries.

Preferably a whole lot of queries.  All the measurement techniques I can
think of are going to have a great deal of noise, so you shouldn't
twiddle these cost settings based on just a few examples.

            regards, tom lane

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Automagic tuning
Next
From: Cosimo Streppone
Date:
Subject: High end server and storage for a PostgreSQL OLTP system