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

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Pietro Pugni <pietro(dot)pugni(at)gmail(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <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-15 23:47:44
Message-ID: CAMkU=1zoR6b-1=Dag0oLX9HZVhCpmkccPC5cAWGu2WBF_qnZoQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Nov 14, 2016 at 3:45 AM, Pietro Pugni <pietro(dot)pugni(at)gmail(dot)com>
wrote:

>
> The first issue I faced was about maintenance_work_mem because I set it to
> 16GB and the server silently crashed during a VACUUM because I didn’t
> consider that it could take up to autovacuum_max_workers *
> maintenance_work_mem (roughly 48GB).
>

I don't think that this is the true cause of the problem. In current
versions of PostgreSQL, VACUUM cannot make use of more than 1GB of
process-local memory, even if maintenance_work_mem is set to a far greater
value.

Cheers,

Jeff

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Gabriela Serventi 2016-11-16 00:50:46 Re: Performance decrease after upgrade to 9.6.1
Previous Message Tom Lane 2016-11-15 22:35:03 Re: Performance decrease after upgrade to 9.6.1