Re: Regarding Hardware Tuning

On Thu, Dec 19, 2013 at 4:40 PM, Steve Crawford
<scrawford@pinpointresearch.com> wrote:
> On 12/18/2013 12:12 PM, prashant Pandey wrote:
>>
>> Could you tell me each and every hardware parameters and OS parameters the
>> performance depends on.
>> I need the complete list of all the required parameters and how to extract
>> them on Linux through system calls and files.
>> Please it will be highly great full of you to do so.
>> Thank you and regards.
>
>
> This is not even possible given the variety of hardware, OS variants,
> work-loads, database sizes, etc. The answer is really "all of them." Those
> who specialize in tuning constantly run test cases to tease out clues to
> performance tuning and even they most likely couldn't answer this.
>
> The closest you are likely to come is to read and reread "PostgreSQL High
> Performance" which is an invaluable resource.

The ebook edition is on sale for $5.00 which is a STEAL.

http://www.packtpub.com/postgresql-90-high-performance/book