Re: pg_restore out of memory

From: Miguel Ramos <org(dot)postgresql(at)miguel(dot)ramos(dot)name>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_restore out of memory
Date: 2016-07-12 11:54:47
Message-ID: 22aa783f-a642-88c4-36b6-169cfec3be08@miguel.ramos.name
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


À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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Felipe Santos 2016-07-12 12:02:57 Re: pg_restore out of memory
Previous Message David Rowley 2016-07-12 11:50:47 Re: Question about antijoin