| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
| Cc: | prashant Pandey <prashantpandeyfun10(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Regarding Hardware Tuning |
| Date: | 2013-12-20 00:37:19 |
| Message-ID: | CAOR=d=2GCVxgC7SPWK8g_bwRWp=dXkg9nEc7_kyZ9nyRAb2uKA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Thu, Dec 19, 2013 at 4:40 PM, Steve Crawford
<scrawford(at)pinpointresearch(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc Cousin | 2013-12-20 06:05:35 | Re: query plan not optimal |
| Previous Message | Dave Johansen | 2013-12-20 00:35:11 | DATE_TRUNC() and GROUP BY? |