pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedRegarding Hardware Tuning
4+ messages / 4 participants
[nested] [flat]
* Regarding Hardware Tuning
@ 2013-12-18 20:12 prashant Pandey <prashantpandeyfun10@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: prashant Pandey @ 2013-12-18 20:12 UTC (permalink / raw)
To: pgsql-performance
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Regarding Hardware Tuning
@ 2013-12-19 23:40 Steve Crawford <scrawford@pinpointresearch.com>
parent: prashant Pandey <prashantpandeyfun10@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Steve Crawford @ 2013-12-19 23:40 UTC (permalink / raw)
To: prashant Pandey <prashantpandeyfun10@gmail.com>; pgsql-performance
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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Regarding Hardware Tuning
@ 2013-12-20 00:37 Scott Marlowe <scott.marlowe@gmail.com>
parent: Steve Crawford <scrawford@pinpointresearch.com>
0 siblings, 1 reply; 4+ messages in thread
From: Scott Marlowe @ 2013-12-20 00:37 UTC (permalink / raw)
To: Steve Crawford <scrawford@pinpointresearch.com>; +Cc: prashant Pandey <prashantpandeyfun10@gmail.com>; pgsql-performance
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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Regarding Hardware Tuning
@ 2013-12-20 14:29 Shaun Thomas <sthomas@optionshouse.com>
parent: Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Shaun Thomas @ 2013-12-20 14:29 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; Steve Crawford <scrawford@pinpointresearch.com>; +Cc: prashant Pandey <prashantpandeyfun10@gmail.com>; pgsql-performance
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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2013-12-20 14:29 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-12-18 20:12 Regarding Hardware Tuning prashant Pandey <prashantpandeyfun10@gmail.com>
2013-12-19 23:40 ` Steve Crawford <scrawford@pinpointresearch.com>
2013-12-20 00:37 ` Scott Marlowe <scott.marlowe@gmail.com>
2013-12-20 14:29 ` Shaun Thomas <sthomas@optionshouse.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox