Re: [TIPS] Tuning PostgreSQL 9.2 - Mailing list pgsql-admin

From drum.lucas@gmail.com
Subject Re: [TIPS] Tuning PostgreSQL 9.2
Date
Msg-id CAE_gQfWG3oCav7q_TOyqgNnOfkKHMyocW_AJ0eCBen0W_fOXeQ@mail.gmail.com
Whole thread Raw
In response to Re: [TIPS] Tuning PostgreSQL 9.2  (Scott Whitney <scott@journyx.com>)
Responses Re: [TIPS] Tuning PostgreSQL 9.2  (Payal Singh <payal@omniti.com>)
List pgsql-admin


On 19 February 2016 at 06:56, Scott Whitney <scott@journyx.com> wrote:
Echoing (other) Scott's comments, specifically, when he says "what does your IO subsystem looks like," what's the hardware? RAID 10 is all well and good, but how many drives, what type are they, and how is your RAID-10 configured? Specific model numbers would be useful.



 HI there! 

So... 

The disks are:

HP 3TB 6G SAS 7.2K 3.5inch HDD,, HDD RPM: 7200, GB Hard Drive: 3072 

HP Smart Array P840/4GB FBWC 12Gb/s SAS Raid Controller 

raid 10

LVM with ext4 filesystem

pgsql-admin by date:

Previous
From: Evan Rempel
Date:
Subject: Re: 9.5 new setting "cluster name" and logging
Next
From: Payal Singh
Date:
Subject: Re: [TIPS] Tuning PostgreSQL 9.2