Re: Tuning Linux for Postgresql - Database failed to start - Mailing list pgsql-admin

From Kenneth Marshall
Subject Re: Tuning Linux for Postgresql - Database failed to start
Date
Msg-id 20220510204855.GE7402@aart.rice.edu
Whole thread Raw
In response to Re: Tuning Linux for Postgresql - Database failed to start  (Albin Ary <albinary10@gmail.com>)
Responses Re: Tuning Linux for Postgresql - Database failed to start  (Albin Ary <albinary10@gmail.com>)
List pgsql-admin
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



pgsql-admin by date:

Previous
From: Albin Ary
Date:
Subject: Re: Tuning Linux for Postgresql - Database failed to start
Next
From: Albin Ary
Date:
Subject: Re: Tuning Linux for Postgresql - Database failed to start