Re: Blocked updates and background writer performance

From: Cory Tucker <cory(dot)tucker(at)gmail(dot)com>
To: Vick Khera <vivek(at)khera(dot)org>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Blocked updates and background writer performance
Date: 2016-01-13 19:17:47
Message-ID: CAG_=8kAHPjSSUcGFZnkBOFm12WjTp91uDadfh5d9fsiAj778uw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jan 13, 2016 at 9:48 AM Vick Khera <vivek(at)khera(dot)org> wrote:

> That was my intuition too. Not enough I/O available from the hardware for
> the workload requested.
>
> As recommended, log your checkpoints and try tuning them to spread the
> load.
>

Thanks guys, will turn on checkpoint logging and try to sniff this out
further.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2016-01-13 19:38:31 pg_dump problem with dropped NOT NULL on child table
Previous Message Adrian Klaver 2016-01-13 19:07:41 Re: Function error