Thread: PostgreSQL consuming high memory causing restart
A description of what you are trying to achieve and what results you expect.: PostgreSQL is consuming high memory causes restart PostgreSQL version number you are running: psql (PostgreSQL) 15.8 How you installed PostgreSQL: in containerised environment with patroni Changes made to the settings in the postgresql.conf file: autovacuum_max_workers: 4, autovacuum_vacuum_cost_limit: 200, autovacuum_vacuum_scale_factor: 0.2 Operating system and version: RHEL 9.4 What program you're using to connect to PostgreSQL: python Is there anything relevant or unusual in the PostgreSQL server logs?:2024-09-12 02:44:47.231 IST [1057] WARNING: autovacuum worker took too long to start; canceled
2024-09-12 02:44:47.421 IST [1095741] WARNING: autovacuum worker started without a worker entry
2024-09-12 02:46:01.043 IST [1095743] LOG: could not send data to client: Broken pipe
2024-09-12 02:46:01.050 IST [1095743] FATAL: connection to client lost
2024-09-12 02:46:28.696 IST [1050] LOG: received fast shutdown requestAborts all idle connections and recovery
2024-09-12 02:46:53.909 IST [1095835] LOG: checkpoint starting: force
2024-09-12 02:46:53.925 IST [1095832] LOG: database system is ready to accept connections For questions about any kind of error: What you were doing when the error happened / how to cause the error: no specific operation , sytem is running for few days The EXACT TEXT of the error message you're getting, if there is one: (Copy and paste the message to the email, do not send a screenshot)
Disclaimer
This e-mail together with any attachments may contain information of Ribbon Communications Inc. and its Affiliates that is confidential and/or proprietary for the sole use of the intended recipient. Any review, disclosure, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please notify the sender immediately and then delete all copies, including any attachments.
There might be a couple of potential reasons for the high memory consumption you're experiencing
1) If the memory-related settings are not optimally tuned, it can lead to high memory usage. For instance, if system resources are limited but memory settings are configured with larger values, it could cause this issue. Please double-check your memory-related settings, specifically shared_buffers, work_mem, maintenance_work_mem, and effective_cache_size.
SELECT pid, age(clock_timestamp(), query_start), usename, query FROM pg_stat_activity WHERE state != 'idle' ORDER BY age(clock_timestamp(), query_start) DESC;
Hi team,We are facing postgresql memory consuming issue which causes postgresql restart.A description of what you are trying to achieve and what results you expect.: PostgreSQL is consuming high memory causes restart PostgreSQL version number you are running: psql (PostgreSQL) 15.8 How you installed PostgreSQL: in containerised environment with patroni Changes made to the settings in the postgresql.conf file: autovacuum_max_workers: 4, autovacuum_vacuum_cost_limit: 200, autovacuum_vacuum_scale_factor: 0.2 Operating system and version: RHEL 9.4 What program you're using to connect to PostgreSQL: python Is there anything relevant or unusual in the PostgreSQL server logs?:2024-09-12 02:44:47.231 IST [1057] WARNING: autovacuum worker took too long to start; canceled
2024-09-12 02:44:47.421 IST [1095741] WARNING: autovacuum worker started without a worker entry
2024-09-12 02:46:01.043 IST [1095743] LOG: could not send data to client: Broken pipe
2024-09-12 02:46:01.050 IST [1095743] FATAL: connection to client lost
2024-09-12 02:46:28.696 IST [1050] LOG: received fast shutdown requestAborts all idle connections and recovery
2024-09-12 02:46:53.909 IST [1095835] LOG: checkpoint starting: force
2024-09-12 02:46:53.925 IST [1095832] LOG: database system is ready to accept connections For questions about any kind of error: What you were doing when the error happened / how to cause the error: no specific operation , sytem is running for few days The EXACT TEXT of the error message you're getting, if there is one: (Copy and paste the message to the email, do not send a screenshot)Regards,Sagar PopadeDisclaimer
This e-mail together with any attachments may contain information of Ribbon Communications Inc. and its Affiliates that is confidential and/or proprietary for the sole use of the intended recipient. Any review, disclosure, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please notify the sender immediately and then delete all copies, including any attachments.