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
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 |