From: | Bryan Keller <bryanck(at)gmail(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Postgresql 9.2 OOM |
Date: | 2012-09-30 04:38:37 |
Message-ID: | 4206091F-1E97-4D8E-96DA-0861045FDCD1@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I recently upgraded from Postgresql 9.0.10 to 9.2.1. I am now running into problems with Postgresql running out of memory during large data operations, more specifically loading the OpenStreetMap data into the database. The load under 9.0 went fine and there were no memory issues. This is on the exact same machine, same postgresql.conf, same everything except for the upgrade to 9.2. Initially the OOM killer was kicking in and killing Postgresql. Once I set vm.overcommit_memory=2, Postgresql just reports it is OOM rather than being killed. It seems the Postgresql process keeps using up more and more memory until it eventually fails, almost as if there is a leak.
Are there any new 9.2 memory usage parameters I may have overlooked? Here are some parameters I have set that worked fine under 9.0:
max_connections = 100
max_locks_per_transaction = 100
effective_cache_size=8GB
shared_buffers=4GB
work_mem=8MB
maintenance_work_mem=4GB
synchronous_commit=off
checkpoint_segments=100
checkpoint_timeout=10min
checkpoint_completion_target=0.9
The machine has 12 cores (24 w/ HT), 24 GB RAM, and is running CentOS 6.3 64-bit with all of the latest updates applied. As I mentioned, over time, the Postgresql processes keep increasing memory usage until all physical memory is used up, and the process then fails.
From | Date | Subject | |
---|---|---|---|
Next Message | bryanck | 2012-09-30 05:07:07 | Re: Postgresql 9.2 OOM |
Previous Message | Scott Marlowe | 2012-09-30 00:36:27 | Re: Would my postgresql 8.4.12 profit from doubling RAM? |