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

From: Saurabh Nanda <saurabhnanda(at)gmail(dot)com>
To: 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:03:31
Message-ID: CAPz=2oFaS-xeVdYuidrXV9zvp-+d+x713K52rdgfp09HaP+Q4A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

-- Saurabh.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Nicolas Charles 2019-01-28 14:22:19 Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"?
Previous Message Arne Roland 2019-01-28 13:50:50 RE: dsa_allocate() faliure