Postgres Pro
Downloads
Home   >   mailing lists

Re: Some tuning suggestions on a Red Hat 6.7 - PG 9.5.3 production environment - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: Some tuning suggestions on a Red Hat 6.7 - PG 9.5.3 production environment
Date
Msg-id CAHyXU0zH+_UFTHd_o8kHkO3HSvdq6vMZURptGjmDdjZC6dA=cQ@mail.gmail.com
Whole thread Raw
In response to Re: Some tuning suggestions on a Red Hat 6.7 - PG 9.5.3 production environment  (domenico febbo <mimmopasticcio@gmail.com>)
List pgsql-performance
Tree view 
On Mon, Nov 14, 2016 at 11:36 AM, domenico febbo
<mimmopasticcio@gmail.com> wrote:
> dear Pietro,
> are you sure about
>
> effective_io_concurrency = 30
>
> could you please explain the type of disk storage?

fast storage can certainly utilize high settings of
effective_io_concurrency at least in some cases...for example see:
https://www.postgresql.org/message-id/CAHyXU0yiVvfQAnR9cyH%3DHWh1WbLRsioe%3DmzRJTHwtr%3D2azsTdQ%40mail.gmail.com

merlin

pgsql-performance by date:

Previous
From: Pietro Pugni
Date:
Subject: Re: Some tuning suggestions on a Red Hat 6.7 - PG 9.5.3 production environment
Next
From: Seckin Pulatkan
Date:
Subject: Re: Query planner chooses index scan backward instead of better index option