MIME-Version: 1.0
References: 
 <CAGCWzU+OhJ7Z938nmkQh4yRijEKow3VC+t0dYgmErPcsEDeYpg@mail.gmail.com>
 <3C248C6F-BB01-4E18-8427-EE46B9B48762@elevated-dev.com>
 <CAGCWzU++r4o+JAWPn8xn1yA+KncBz1=U22tjsw4Fw_d4a-wwTw@mail.gmail.com>
 <20220510204855.GE7402@aart.rice.edu>
In-Reply-To: <20220510204855.GE7402@aart.rice.edu>
From: Albin Ary <albinary10@gmail.com>
Date: Tue, 10 May 2022 22:58:15 +0200
Message-ID: 
 <CAGCWzULiS+_adPDmMPw7dJKG9+fSAdAQchatogDCv1gwV-giBw@mail.gmail.com>
Subject: Re: Tuning Linux for Postgresql - Database failed to start
To: Kenneth Marshall <ktm@rice.edu>
Cc: pgsql-admin@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000003ba5d505deae964e"
Archived-At: 
 <https://www.postgresql.org/message-id/CAGCWzULiS%2B_adPDmMPw7dJKG9%2BfSAdAQchatogDCv1gwV-giBw%40mail.gmail.com>
Precedence: bulk

--0000000000003ba5d505deae964e
Content-Type: text/plain; charset="UTF-8"

Ok, will do that. Thanks a lot.

It is clear now why it fails to start.

Actually, the blog author mentions that setting it high might cause the
database failing to start, anyway a calculation is provided and I followed
that calculation.


The ideal number of huge pages is just a bit higher than this -- just a
> bit. If you increase this value too much, processes that need small pages
> that also need space in the OS will fail to start. This may even end up
> with the operating system failing to boot or other PostgreSQL instances on
> the same server failing to start.


On Tue, 10 May 2022 at 22:48, Kenneth Marshall <ktm@rice.edu> wrote:

> On Tue, May 10, 2022 at 10:39:09PM +0200, Albin Ary wrote:
> > Hello,
> >
> > Thanks a lot for your inputs.
> >
> > I only changed the section related to HugePages.
> >
> > This server has 4 GB RAM.
> >
> > shared_buffers = '1GB'
> > vm.nr_hugepages=650
> >
> > tuned profile:
> >
> Hi Albin,
>
> 1GB shared_buffers + 1.3GB huge pages on a 4GB system = don't have
> enough resources. Please remove the huge pages request or add additional
> memory to your system.
>
> Regards,
> Ken
>

--0000000000003ba5d505deae964e
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Ok, will do that. Thanks a lot.=C2=A0<div><br></div><div>I=
t is clear now why it fails to start.=C2=A0</div><div><br></div><div>Actual=
ly, the blog author mentions that setting it high might cause the database =
failing to start, anyway a calculation is provided and I=C2=A0followed that=
 calculation.=C2=A0</div><div><br></div><div><br></div><blockquote class=3D=
"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(2=
04,204,204);padding-left:1ex"><span style=3D"color:rgb(0,0,0);font-family:S=
upreme-Variable,ui-sans-serif,system-ui,-apple-system,BlinkMacSystemFont,&q=
uot;Segoe UI&quot;,Roboto,&quot;Helvetica Neue&quot;,Arial,&quot;Noto Sans&=
quot;,sans-serif,&quot;Apple Color Emoji&quot;,&quot;Segoe UI Emoji&quot;,&=
quot;Segoe UI Symbol&quot;,&quot;Noto Color Emoji&quot;;font-size:16px">The=
 ideal number of huge pages is just a bit higher than this -- just a bit. I=
f you increase this value too much, processes that need small pages that al=
so need space in the OS will fail to start. This may even end up with the o=
perating system failing to boot or other PostgreSQL instances on the same s=
erver failing to start.</span></blockquote><div><br><div><br></div><div><br=
></div></div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D=
"gmail_attr">On Tue, 10 May 2022 at 22:48, Kenneth Marshall &lt;<a href=3D"=
mailto:ktm@rice.edu">ktm@rice.edu</a>&gt; wrote:<br></div><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex">On Tue, May 10, 2022 at 10:39:09PM +0200, =
Albin Ary wrote:<br>
&gt; Hello,<br>
&gt; <br>
&gt; Thanks a lot for your inputs.<br>
&gt; <br>
&gt; I only changed the section related to HugePages.<br>
&gt; <br>
&gt; This server has 4 GB RAM.<br>
&gt; <br>
&gt; shared_buffers =3D &#39;1GB&#39;<br>
&gt; vm.nr_hugepages=3D650<br>
&gt; <br>
&gt; tuned profile:<br>
&gt; <br>
Hi Albin,<br>
<br>
1GB shared_buffers + 1.3GB huge pages on a 4GB system =3D don&#39;t have<br=
>
enough resources. Please remove the huge pages request or add additional<br=
>
memory to your system.<br>
<br>
Regards,<br>
Ken<br>
</blockquote></div>

--0000000000003ba5d505deae964e--