[PERFORM] Regarding Hardware Tuning

This looks like a nice little $5 stocking filler for christmas … was looking through the sample chapters and i see some strong reservation re ssd technology.


---------- Forwarded message ----------

From: Scott Marlowe scott.marlowe@gmail.com
Date: 20 December 2013 01:37
Subject: Re: [PERFORM] Regarding Hardware Tuning

To: Steve Crawford scrawford@pinpointresearch.com
Cc: prashant Pandey prashantpandeyfun10@gmail.com, “pgsql-performance@postgresql.orgpgsql-performance@postgresql.org

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.


Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)

To make changes to your subscription: