[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: [PERFORM] Some tuning suggestions on a Red Hat 6.7 - PG 9.5.3 production environment
From:       Jeff Janes <jeff.janes () gmail ! com>
Date:       2016-11-15 23:47:44
Message-ID: CAMkU=1zoR6b-1=Dag0oLX9HZVhCpmkccPC5cAWGu2WBF_qnZoQ () mail ! gmail ! com
[Download RAW message or body]

On Mon, Nov 14, 2016 at 3:45 AM, Pietro Pugni <pietro.pugni@gmail.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

[Attachment #3 (text/html)]

<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Mon, Nov 14, 2016 \
at 3:45 AM, Pietro Pugni <span dir="ltr">&lt;<a href="mailto:pietro.pugni@gmail.com" \
target="_blank">pietro.pugni@gmail.com</a>&gt;</span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div style="word-wrap:break-word"><div><br></div><div>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). \
</div></div></blockquote><div><br></div><div>I don&#39;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.</div><div><br></div><div>Cheers,</div><div><br></div><div>Jeff</div><div><br></div><div><br></div></div></div></div>




[prev in list] [next in list] [prev in thread] [next in thread]