Re: Simple postgresql.conf wizard - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Simple postgresql.conf wizard
Date
Msg-id 26553.1227160260@sss.pgh.pa.us
Whole thread Raw
In response to Re: Simple postgresql.conf wizard  ("Dann Corbit" <DCorbit@connx.com>)
Responses Re: Simple postgresql.conf wizard  (Decibel! <decibel@decibel.org>)
List pgsql-hackers
"Dann Corbit" <DCorbit@connx.com> writes:
>> I think the idea that there IS a magic number is the problem.
>> 
>> No amount of testing is ever going to refute the argument that, under
>> some other workload, a different value might better.
>> 
>> But that doesn't amount to a reason to leave it the way it is.

> Perhaps a table of experimental data could serve as a rough guideline.

The problem is not that anyone wants to leave it the way it is.
The problem is that no one has done even a lick of work to identify
a specific number that is demonstrably better than others -- on *any*
scale.  How about fewer complaints and more effort?
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Pavan Deolasee"
Date:
Subject: Re: [PATCHES] Infrastructure changes for recovery (v8)
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: HEAD build failure on win32 mingw