Обсуждение: Regarding Hardware Tuning

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.

Cheers,
Steve

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

On 12/19/2013 06:37 PM, Scott Marlowe wrote:

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

Wow, I guess I should pay better attention to all those annoying emails
Packt sends me. That'll make a good portable copy since I tend to keep
the real version on my bookshelf at home. :)

This is good advice, by the way. Greg's book is great, especially for
newly minted DBAs who might have trouble deciding on where to start.
Though from what I've been seeing on the list recently, they need to
have him update it for 9.2 and 9.3 with all of the changes in the last
couple versions. There are also a ton of considerations regarding new
Linux kernel settings.

Greg, go tell Packt they need to pay you to write the second edition. ;)

--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
sthomas@optionshouse.com

______________________________________________

See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email