Re: New PG14 server won't start with >2GB shared_buffers

From: Chris Hoover <chrish(at)aweber(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: New PG14 server won't start with >2GB shared_buffers
Date: 2023-02-25 03:29:47
Message-ID: 4D0088DC-C22D-4459-A793-72FC7402DC94@aweber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

This is bare metal.

Thanks,

Chris Hoover

Sent from my iPhone

> On Feb 24, 2023, at 21:19, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Chris Hoover <chrish(at)aweber(dot)com> writes:
>> I have a new server that has 1TB ram (not a typo). I have been fighting with this evening to start up with a shared_buffer setting over 2GB. When the memory allocation breaks 2GB, the database won’t start. I’ve dropped it down to 500M to get the database online. We’ve tried both SysV memory and mmap memory.
>
> Are you running inside a VM, or cgroup, or something else that might
> be imposing a memory limit?
>
> regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2023-02-25 10:25:10 Re: New PG14 server won't start with >2GB shared_buffers
Previous Message Tom Lane 2023-02-25 02:19:52 Re: New PG14 server won't start with >2GB shared_buffers