Re: effective_io_concurrency on EBS/gp2 - Mailing list pgsql-performance

From Rick Otten
Subject Re: effective_io_concurrency on EBS/gp2
Date
Msg-id CAMAYy4K2tqAsqfaQmy0_AhE-Unxmk_6gRrmxdfJm=EdCrXO7WQ@mail.gmail.com
Whole thread Raw
In response to Re: effective_io_concurrency on EBS/gp2  (Vitaliy Garnashevich <vgarnashevich@gmail.com>)
Responses Re: effective_io_concurrency on EBS/gp2  (Vitaliy Garnashevich <vgarnashevich@gmail.com>)
List pgsql-performance


On Thu, Feb 8, 2018 at 11:40 AM, Vitaliy Garnashevich <vgarnashevich@gmail.com> wrote:
Anyway, there are still some strange things happening when effective_io_concurrency is non-zero.

...
 
Vitaliy


I was researching whether I could optimize a concatenated lvm2 volume when I have disks of different speeds (concatenated - not striped - and I think I can if I concatenate them in the right order - still testing on that front), when I came across this article from a few years ago:

In the article he talks about the performance of parallel io on different file systems.

Since I am already running XFS that led me to this tunable:

Which brought me back to this discussion about effective_io_concurrency from a couple of weeks ago.  I noticed that the recent round of tests being discussed never mentioned the file system used.  Was it XFS?  Does changing the agcount change the behaviour?


pgsql-performance by date:

Previous
From: MichaelDBA
Date:
Subject: Re: need advice to tune postgresql
Next
From: Laurenz Albe
Date:
Subject: Re: need advice to tune postgresql