On Thu, Dec 19, 2013 at 4:40 PM, Steve Crawford <scrawford@xxxxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance