From: | Dmitrii Golub <dmitrii(dot)golub(at)gmail(dot)com> |
---|---|
To: | Edgar Delgado <edgdelgado(at)gmail(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Out of memory psql import! |
Date: | 2016-03-21 23:25:44 |
Message-ID: | CAN1orqn31DYg1sPT+BFrbumPPVxGgfLKsYm4kQtFnAavVoOyWA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
2016-03-22 0:07 GMT+03:00 Edgar Delgado <edgdelgado(at)gmail(dot)com>:
> well...
>
> I guess with pg_dump is working now! 30mins and no OOM error
>
> 2016-03-21 17:20 GMT-03:00 Edgar Delgado <edgdelgado(at)gmail(dot)com>:
>
>> Not yet!
>>
>> doing a pg_dump right now...
>>
>> also, the OOM occurs in a copy event of a 2gb table.
>>
>> droped work_mem to 2gb and trying again with psql while doing a pg_dump
>>
>> I just did "psql database < stuff.sql"
>>
>> 2016-03-21 17:13 GMT-03:00 Dmitrii Golub <dmitrii(dot)golub(at)gmail(dot)com>:
>>
>>> 2016-03-21 23:02 GMT+03:00 Edgar Delgado <edgdelgado(at)gmail(dot)com>:
>>>
>>>> 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
>>>>
>>>>
>>>>
>>>>
>>> Please, tell us how are you doing this exactly.
>>> Did you try pg_dump, pg_restore?
>>>
>>> --
>>> Dmitrii Golub
>>>
>>
>>
>
well done
--
Dmitrii Golub
From | Date | Subject | |
---|---|---|---|
Next Message | Nicolas Aubert | 2016-03-22 06:35:03 | Re: vacuum analyse waiting |
Previous Message | Edgar Delgado | 2016-03-21 21:07:41 | Re: Out of memory psql import! |