Cannot allocate memory

From: "Heng Zhi Feng (zheng(at)hsr(dot)ch)" <zheng(at)hsr(dot)ch>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Cannot allocate memory
Date: 2013-11-15 10:25:23
Message-ID: CADBC8F358BE2845B978CF56956066AF04F60F71@SID00202.hsr.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

We have a problem where PostgreSQL will restart or shutdown when calling it through PDAL write filter. This was after we applied pgtune on the postgresql.conf.

These are the settings on the machine:
Virtual Machine - Ubuntu 13.10
1.92GB Memory
2 Parallel Processors

And these are the configurations from pgtune:
#------------------------------------------------------------------------------
# CUSTOMIZED OPTIONS
#------------------------------------------------------------------------------
default_statistics_target = 50 # pgtune wizard 2013-11-14
maintenance_work_mem = 112MB # pgtune wizard 2013-11-14
constraint_exclusion = on # pgtune wizard 2013-11-14
checkpoint_completion_target = 0.9 # pgtune wizard 2013-11-14
effective_cache_size = 1408MB # pgtune wizard 2013-11-14
work_mem = 11MB # pgtune wizard 2013-11-14
wal_buffers = 8MB # pgtune wizard 2013-11-14
checkpoint_segments = 16 # pgtune wizard 2013-11-14
shared_buffers = 448MB # pgtune wizard 2013-11-14
max_connections = 80 # pgtune wizard 2013-11-14

I have also set the shmmax to a higher value to adapt to the new configurations but it does not seem to solve the problem.

Below is a snippet of the postgresql.log:
2013-11-15 11:02:35 CET LOG: could not fork autovacuum worker process: Cannot allocate memory
2013-11-15 11:02:36 CET LOG: could not send data to client: Broken pipe
2013-11-15 11:02:36 CET LOG: unexpected EOF on client connection

Thanks

Zhi Feng

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Sawada Masahiko 2013-11-15 10:27:15 Re: Logging WAL when updating hintbit
Previous Message Andres Freund 2013-11-15 09:49:39 Re: init_sequence spill to hash table