Re: [TIPS] Tuning PostgreSQL 9.2

[Payal Singh <payal@xxxxxxxxxx>]

Following are some helpful links to help you tune your system better:

https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server

http://evol-monkey.blogspot.com/2013/08/setting-sharedbuffers-hard-way.html

https://wiki.postgresql.org/wiki/Performance_Optimization

Plenty of other resources online.

Payal Singh,
Database Administrator,

OmniTI Computer Consulting Inc.
Phone: 240.646.0770 x 253

On Thu, Feb 18, 2016 at 5:15 PM, drum.lucas@xxxxxxxxx <drum.lucas@xxxxxxxxx> wrote:

On 19 February 2016 at 06:56, Scott Whitney <scott@xxxxxxxxxxx> 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