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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Chris Hoover <chrish(at)aweber(dot)com>
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 02:19:52
Message-ID: 1088615.1677291592@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Chris Hoover 2023-02-25 03:29:47 Re: New PG14 server won't start with >2GB shared_buffers
Previous Message Chris Hoover 2023-02-25 02:08:58 New PG14 server won't start with >2GB shared_buffers