From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Christian Schröder <christian(dot)schroeder(at)wsd(dot)com> |
Cc: | Francisco Olarte <folarte(at)peoplecall(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, Eric Wong <eric(dot)wong(at)wsd(dot)com> |
Subject: | Re: Memory issues with PostgreSQL 15 |
Date: | 2024-05-29 21:43:41 |
Message-ID: | 3332.1717019021@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
=?utf-8?B?Q2hyaXN0aWFuIFNjaHLDtmRlcg==?= <christian(dot)schroeder(at)wsd(dot)com> writes:
> # ipcs -m
> ------ Shared Memory Segments --------
> key shmid owner perms bytes nattch status
> 0x04000194 35 postgres 600 56 19
> I am surprised to see this since I would have expected much more shared memory to be used by the database. Is there anything in the configuration that prevents the shared memory from being used?
SysV shared memory isn't that relevant to Postgres anymore. Most
of what we allocate goes into POSIX-style shared memory segments,
which are not shown by "ipcs". We do still create one small
fixed-size data structure in SysV memory, which is what you're
seeing here, for arcane reasons having to do with the lifespan of
the shared memory segments being different in those two APIs.
>> <2024-05-21 11:34:46 CEST - mailprocessor> ERROR: could not resize
>> shared memory segment "/PostgreSQL.2448337832" to 182656 bytes: No
>> space left on device
This seems to indicate that you're hitting some kernel limit on
the amount of POSIX shared memory. Not sure where to look for
that.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Juan Rodrigo Alejandro Burgos Mella | 2024-05-30 02:45:37 | Re: Dll libpq.dll 32 bits |
Previous Message | José Mello Júnior | 2024-05-29 18:45:57 | Re: Dll libpq.dll 32 bits |