From: | jian xu <jamesxu(at)outlook(dot)com> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | checkpoint process use too much memory |
Date: | 2020-04-19 13:56:56 |
Message-ID: | MN2PR05MB68322593E34D4BF78AD45137A1D70@MN2PR05MB6832.namprd05.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello,
My pg version is 10.3, last week my user got error :
OperationalError: (psycopg2.OperationalError) could not fork new process for connection: Cannot allocate memory
could not fork new process for connection: Cannot allocate memory
when I checked the database, I found checkpoint process used too much memory, htop showed
VIRT: 171GB
RES: 171GB
SHR:4176MB
MEM%: 70%
Command: Posgres: checkpointer process
The postgresq.conf is
Shared_buffers = 4GB
Work_mem = 128MB
Maintenance_work_mem = 2GB
Wal_level = replica
Wal_buffer = 16MB
Checkpoint_completion_target = 0.7
How can I troubleshooting this error? Why checkpoint process used so much memory? it sounds like a memory leak issue in checkpointer process.
Thanks for your help!
James
From | Date | Subject | |
---|---|---|---|
Next Message | Keith | 2020-04-19 18:26:36 | Re: VACUUM freeze |
Previous Message | Olivier Gautherot | 2020-04-19 13:24:53 | Re: VACUUM freeze |