Thread: Regarding Hardware Tuning
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.
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