Re: Some tuning suggestions on a Red Hat 6.7 - PG 9.5.3 production environment

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: domenico febbo <mimmopasticcio(at)gmail(dot)com>
Cc: Pietro Pugni <pietro(dot)pugni(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org list" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Some tuning suggestions on a Red Hat 6.7 - PG 9.5.3 production environment
Date: 2016-11-14 21:24:03
Message-ID: CAHyXU0zH+_UFTHd_o8kHkO3HSvdq6vMZURptGjmDdjZC6dA=cQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Nov 14, 2016 at 11:36 AM, domenico febbo
<mimmopasticcio(at)gmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Seckin Pulatkan 2016-11-15 08:44:57 Re: Query planner chooses index scan backward instead of better index option
Previous Message Pietro Pugni 2016-11-14 20:50:38 Re: Some tuning suggestions on a Red Hat 6.7 - PG 9.5.3 production environment