Home > mailing lists

Out of memory psql import! - Mailing list pgsql-admin

From	Edgar Delgado
Subject	Out of memory psql import!
Date	March 21, 2016 23:03:19
Msg-id	CAENQbUOZrvQtwBCBx+oPOaYL-PM61ux1LZnMgrZ7kPDTfeJx9Q@mail.gmail.com Whole thread Raw
Responses	Re: Out of memory psql import! (Dmitrii Golub <dmitrii.golub@gmail.com>)
List	pgsql-admin

Hi,

Im trying to import a 9.4 database to a 9.5.1 system with psql but after few minutes I get OOM error...

Have 15gb ram.

Tried pgtune conf and still get error

shared_buffers = 3840MB

effective_cache_size = 11520MB

work_mem = 19660kB

maintenance_work_mem = 960MB

min_wal_size = 1GB

max_wal_size = 2GB

checkpoint_completion_target = 0.7

wal_buffers = 16MB

default_statistics_target = 100

From: bricklen
Date: 21 March 2016, 18:37:15
Subject: Re: vacuum analyse waiting

From: Dmitrii Golub
Date: 21 March 2016, 23:13:47
Subject: Re: Out of memory psql import!