| From: | Payal Singh <payal(at)omniti(dot)com> |
|---|---|
| To: | "drum(dot)lucas(at)gmail(dot)com" <drum(dot)lucas(at)gmail(dot)com> |
| Cc: | Scott Whitney <scott(at)journyx(dot)com>, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: [TIPS] Tuning PostgreSQL 9.2 |
| Date: | 2016-02-18 22:20:55 |
| Message-ID: | CANUg7LB7CzBkFW+XM=m66KRozSDmMtNt93yL2n2kq+bwZZXAAw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(dot)lucas(at)gmail(dot)com <drum(dot)lucas(at)gmail(dot)com>
wrote:
>
>
> On 19 February 2016 at 06:56, Scott Whitney <scott(at)journyx(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | drum.lucas@gmail.com | 2016-02-18 22:24:04 | Re: [TIPS] Tuning PostgreSQL 9.2 |
| Previous Message | drum.lucas@gmail.com | 2016-02-18 22:15:06 | Re: [TIPS] Tuning PostgreSQL 9.2 |