Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? - Mailing list pgsql-performance

From Nicolas Charles
Subject Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"?
Date
Msg-id 71a5e04d-8f2f-385a-2789-c78bf780a622@normation.com
Whole thread Raw
In response to Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"?  (Saurabh Nanda <saurabhnanda@gmail.com>)
Responses Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"?
List pgsql-performance
Le 28/01/2019 à 15:03, Saurabh Nanda a écrit :
> An update. It seems (to my untrained eye) that something is wrong with 
> the second SSD in the RAID configuration. Here's my question on 
> serverfault related to what I saw with iostat - 
>
https://serverfault.com/questions/951096/difference-in-utilisation-reported-by-iostat-for-two-identical-disks-in-raid1
>
> I've disabled RAID and rebooted the server to run the benchmarks with 
> client=1,4,8,12 with shared_buffers=8MB (default) vs 
> shared_buffers=2GB (optimised?) and will report back.
>
>
You should probably include the detailed hardware you are working on - 
especially for the SSD, the model can have a big impact, as well as its 
wear.


Nicolas




pgsql-performance by date:

Previous
From: Saurabh Nanda
Date:
Subject: Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"?
Next
From: Justin Pryzby
Date:
Subject: Re: upgrade from 9.6 to 10/11