public inbox for [email protected]
help / color / mirror / Atom feedFrom: Albin Ary <[email protected]>
To: Kenneth Marshall <[email protected]>
Cc: [email protected]
Subject: Re: Tuning Linux for Postgresql - Database failed to start
Date: Tue, 10 May 2022 22:58:15 +0200
Message-ID: <CAGCWzULiS+_adPDmMPw7dJKG9+fSAdAQchatogDCv1gwV-giBw@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAGCWzU+OhJ7Z938nmkQh4yRijEKow3VC+t0dYgmErPcsEDeYpg@mail.gmail.com>
<[email protected]>
<CAGCWzU++r4o+JAWPn8xn1yA+KncBz1=U22tjsw4Fw_d4a-wwTw@mail.gmail.com>
<[email protected]>
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 <[email protected]> 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
>
view thread (5+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Tuning Linux for Postgresql - Database failed to start
In-Reply-To: <CAGCWzULiS+_adPDmMPw7dJKG9+fSAdAQchatogDCv1gwV-giBw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox