Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"?

From: Nicolas Charles <nicolas(dot)charles(at)normation(dot)com>
To: Saurabh Nanda <saurabhnanda(at)gmail(dot)com>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"?
Date: 2019-01-28 14:22:19
Message-ID: 71a5e04d-8f2f-385a-2789-c78bf780a622@normation.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Justin Pryzby 2019-01-28 15:43:46 Re: upgrade from 9.6 to 10/11
Previous Message Saurabh Nanda 2019-01-28 14:03:31 Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"?