Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_restore out of memory - Mailing list pgsql-general

From Miguel Ramos
Subject Re: pg_restore out of memory
Date
Msg-id 22aa783f-a642-88c4-36b6-169cfec3be08@miguel.ramos.name
Whole thread Raw
In response to Re: pg_restore out of memory  (Felipe Santos <felipepts@gmail.com>)
Responses Re: pg_restore out of memory
List pgsql-general
Tree view 
Às 12:32 de 12-07-2016, Felipe Santos escreveu:
> I would try lowering max_connections to 50 and then set work_mem to 128MB.
>
> After that restart your server and retry the restore.

Ok, I will try restarting tonight.
work_mem is the parameter I was most afraid of.

I'll post some news in 24h...

--
Miguel Ramos

pgsql-general by date:

Previous
From: David Rowley
Date:
Subject: Re: Question about antijoin
Next
From: Felipe Santos
Date:
Subject: Re: pg_restore out of memory