‘ERROR: out of shared memory’ on Postgres server

Google Cloud Apigee
1

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:

  • Can we ignore the error for a while before upgrading to 16.09 shortly?
  • Or, Could it cause any problems such as analytics data lost if we do not increase the size?

Then should they increase ‘shared_buffers’ in the ‘postgresql.conf’ file right away?

Thanks,
Toshi

2

can you ask them to report their postgresql.conf file settings

and also how much physical memory is on their server?

3

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 = 2048MB

The Postgres server has 16GB of physical memory.

4

@Toshihiro Shibamoto make sure yo balance changes to PG config with: