Hi Team,
A customer of Edge Private Cloud 15.07.03 found the following errors on Postgres server node:
2017-05-29 22:15:19,480 pool-5-thread-2 WARN c.a.a.d.c.ServerHandle - ServerHandle.logRetry() : StatementCallback; SQL [ SELECT max( client_received_start_timestamp ) FROM analytics."com.prod.fact" WHERE client_received_start_timestamp>'25 Apr 2017 02:13:54 GMT']; ERROR: out of shared memory; nested exception is org.postgresql.util.PSQLException: ERROR: out of shared memory
Their questions are:
Then should they increase 'shared_buffers' in the 'postgresql.conf' file right away?
Thanks,
Toshi
can you ask them to report their postgresql.conf file settings
and also how much physical memory is on their server?
Hi padmanabhans,
Thank you for following up this case.
Please find the attached data from their conf file.
shared_buffers = 2048MB # min 128kB temp_buffers = 512MB # min 800kB work_mem = 4096MB # min 64kB maintenance_work_mem = 1024MB # min 1MB wal_buffers = 512MB # min 32kB, -1 sets based on shared_buffers checkpoint_segments = 128 # in logfile segments, min 1, 16MB each effective_cache_size = 2048MBThe Postgres server has 16GB of physical memory.
@Toshihiro Shibamoto make sure yo balance changes to PG config with:
User | Count |
---|---|
1 | |
1 | |
1 | |
1 | |
1 |