Re: memory problem with refresh materialized view

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "'info(at)enricopirozzi(dot)info'" <info(at)enricopirozzi(dot)info>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: memory problem with refresh materialized view
Date: 2016-02-12 09:04:31
Message-ID: A737B7A37273E048B164557ADEF4A58B537F7EEA@ntex2010i.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Enrico Pirozzi wrote:
> I have a new postgresql 9.5.0 installation on a new virtual server debian 8.3 x64 with 4gb RAM, I have
> compiled postgresql from source.
>
> When I import a dump with materialized views I see that postgres process takes about all 4 Gb and then
> I have this error
>
> fork: Cannot allocate memory

What are the memory related settings of the database into which you restore?

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Teodor Sigaev 2016-02-12 09:37:36 Re: Test CMake build
Previous Message Albe Laurenz 2016-02-12 09:02:07 Re: PosgreSQL Security Architecture