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