pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Nicolas Charles <nicolas.charles@normation.com>
To: Saurabh Nanda <saurabhnanda@gmail.com>
To: Jeff Janes <jeff.janes@gmail.com>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"?
Date: Mon, 28 Jan 2019 15:22:19 +0100
Message-ID: <71a5e04d-8f2f-385a-2789-c78bf780a622@normation.com> (raw)
In-Reply-To: <CAPz=2oFaS-xeVdYuidrXV9zvp-+d+x713K52rdgfp09HaP+Q4A@mail.gmail.com>
References: <CAPz=2oGdmvirLNX5kys+uiY7LKzCP4sTiXXob39qq6eDkEuk2Q@mail.gmail.com>
	<CAMkU=1yNvhDow9QvKeG5nzv2fDG9VXJ3gi8JbX2h0t8_MY1hBA@mail.gmail.com>
	<CAPz=2oF8C-JAny9eM_gNkzQDj1CDjGfoQ17rcHm5-N-hOFAhUg@mail.gmail.com>
	<CAPz=2oE7HBJo59ANsYoEwyJU3AbjXU1opu_p3MuYZbcja_LCAg@mail.gmail.com>
	<CAMkU=1wn1Hfm+wKxx1sRZ_hEVbt6M5yAVrxXYZA8+B8q2D7-Zg@mail.gmail.com>
	<CAPz=2oHb7W5QzBSt-aAkmFBwC7EAJGxV_0x5OKwA_QeMwZNtbQ@mail.gmail.com>
	<CAPz=2oEN1DRjhWLJNN112xO-vzSGff=Cqgs5oLw9W12y=NMtWw@mail.gmail.com>
	<CAPz=2oEgTA3ENcUGEFQKGug09gWDw7ixrOLXpK3FenTiPVcXxQ@mail.gmail.com>
	<CAPz=2oFaS-xeVdYuidrXV9zvp-+d+x713K52rdgfp09HaP+Q4A@mail.gmail.com>

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-identi...
>
> 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






view thread (22+ messages)  latest in thread

Message-ID: <71a5e04d-8f2f-385a-2789-c78bf780a622@normation.com>
Permalink:  ../71a5e04d-8f2f-385a-2789-c78bf780a622@normation.com/
Also on:    postgresql.org/message-id/71a5e04d-8f2f-385a-2789-c78bf780a622@normation.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: nicolas.charles@normation.com, saurabhnanda@gmail.com, jeff.janes@gmail.com, pgsql-performance@lists.postgresql.org
  Subject: Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"?
  In-Reply-To: <71a5e04d-8f2f-385a-2789-c78bf780a622@normation.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox