{"action":"closed","issue":{"url":"https://api.github.com/repos/dimitri/pgloader/issues/358","repository_url":"https://api.github.com/repos/dimitri/pgloader","labels_url":"https://api.github.com/repos/dimitri/pgloader/issues/358/labels{/name}","comments_url":"https://api.github.com/repos/dimitri/pgloader/issues/358/comments","events_url":"https://api.github.com/repos/dimitri/pgloader/issues/358/events","html_url":"https://github.com/dimitri/pgloader/issues/358","id":140200033,"number":358,"title":"Memory utilization and Performance of pgloader","user":{"login":"devkmd","id":17723187,"avatar_url":"https://avatars.githubusercontent.com/u/17723187?v=3","gravatar_id":"","url":"https://api.github.com/users/devkmd","html_url":"https://github.com/devkmd","followers_url":"https://api.github.com/users/devkmd/followers","following_url":"https://api.github.com/users/devkmd/following{/other_user}","gists_url":"https://api.github.com/users/devkmd/gists{/gist_id}","starred_url":"https://api.github.com/users/devkmd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/devkmd/subscriptions","organizations_url":"https://api.github.com/users/devkmd/orgs","repos_url":"https://api.github.com/users/devkmd/repos","events_url":"https://api.github.com/users/devkmd/events{/privacy}","received_events_url":"https://api.github.com/users/devkmd/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/dimitri/pgloader/labels/How%20To...%20Question","name":"How To... Question","color":"bfe5bf"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-03-11T14:41:06Z","updated_at":"2016-03-27T00:37:11Z","closed_at":"2016-03-27T00:37:11Z","body":"I've a 7.5GB database in mysql that i want to migrate to postgres\r\n\r\ni'am not sure what should be the memory configuration..\r\n\r\nThe .load file has the following statement..\r\n\r\n```\r\nSET maintenance_work_mem to '1028MB', work_mem to '2056MB', search_path to 'postgres'\r\n```\r\n\r\nWould this suffice? Because when i run pgloader with the above setting i get the following message and no migration happens - what memory parameters should i set?\r\n\r\n```\r\nHeap exhausted during allocation: 4653056 bytes available, 4688016 requested.\r\n Gen StaPg UbSta LaSta LUbSt Boxed Unboxed LB   LUB  !move  Alloc  Waste   Trig    WP  GCs Mem-age\r\n   0:  3801     0 130929     0    47     8  4519  4615   276 300104448 1000704 194193736    0   1  0.0000\r\n   1:     0     0     0     0     0     0     0     0     0        0     0 42949672    0   0  0.0000\r\n   2:  3832  4479     0     0   150   181    14 77722   376 2552655920 5443536  2000000   68   0  0.5458\r\n   3:     0     0     0     0     0     0     0     0     0        0     0  2000000    0   0  0.0000\r\n   4:     0     0     0     0     0     0     0     0     0        0     0  2000000    0   0  0.0000\r\n   5:     0     0     0     0     0     0     0     0     0        0     0  2000000    0   0  0.0000\r\n   6:     0     0     0     0  2468  1125     0     0     0 117735424     0  2000000 2289   0  0.0000\r\n   Total bytes allocated    = 2970495792\r\n   Dynamic-space-size bytes = 4294967296\r\nGC control variables:\r\n   *GC-INHIBIT* = false\r\n   *GC-PENDING* = false\r\n   *STOP-FOR-GC-PENDING* = false\r\n\r\ndebugger invoked on a SB-KERNEL::HEAP-EXHAUSTED-ERROR in thread\r\n#<THREAD \"lparallel\" RUNNING {10081B2073}>:\r\n  Heap exhausted (no more space for allocation).\r\n4653056 bytes available, 4688016 requested.\r\n\r\nPROCEED WITH CAUTION.\r\n```\r\n\r\n\r\n"}}