You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have suddenly started getting OOM errors in my Postgres cluster . I have to restart the patroni to log in to the database.
If I can log in by killing any existing session, then I am getting this error :
postgres=# select count(1) from pg_stat_activity;
ERROR: out of memory
LINE 1: select count(1) from pg_stat_activity;
^
DETAIL: Failed on request of size 25462 in memory context "MessageContext".
This issue is not related to cluster deployment but to maintenance issues. Consider sponsorship, some of the subscriptions include individual support.
Where to start:
Check the monitoring system to determine the reason for the increased memory consumption. For example: more connections or a change in workload. Which processes consume memory.
If query optimization is not considered, then try to reduce memory usage (shared_buffers, work_mem, maintenance_work_mem) or increase the resources of the database server.
Monitor database performance metrics when changing parameters. If the memory usage parameters are reduced, performance degradation is possible.
I have suddenly started getting OOM errors in my Postgres cluster . I have to restart the patroni to log in to the database.
If I can log in by killing any existing session, then I am getting this error :
postgresql_parameters:
I tried reducing the work_mem to 64MB and Shared buffer to 1400 MB still it is coming. What approach should I take?
The text was updated successfully, but these errors were encountered: