Re: [TIPS] Tuning PostgreSQL 9.2

I've sent an email to the list, showing the graphs (i think it is waiting
for approval)

In the meantime...

I'm able to change to any of this below, if it will improve my performance:

Replace existing 4x3TB Disk with 1.5TB Silver SAN

Replace existing 4x3TB Disk with 4x800GB SSD Drives (Raid 5)

Replace existing 4x3TB Disk with 8x600GB 15K SAS (Raid 10)
Add 4x3TB to existing Raid 10

On 19 February 2016 at 11:24, drum(dot)lucas(at)gmail(dot)com <drum(dot)lucas(at)gmail(dot)com>
wrote:

>
>
> On 19 February 2016 at 11:20, Payal Singh <payal(at)omniti(dot)com> wrote:
>
>> 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.
>>
>
> Thanks! BUT I'd love to hear from all of you.. sometimes talking each
> other is better than put some random confs in prod. I want to know what u
> guys have been through and, maybe, do some changes here as well.
>