Postgres Pro
Downloads
Home   >   mailing lists

Re: memory problem with refresh materialized view - Mailing list pgsql-general

From Albe Laurenz
Subject Re: memory problem with refresh materialized view
Date
Msg-id A737B7A37273E048B164557ADEF4A58B537F7EEA@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to memory problem with refresh materialized view  (Enrico Pirozzi <sscotty71@gmail.com>)
Responses PostgreSQL 9.5 and process REST calls enquiry  (Peter van Eck <peter@vaneckzone.net>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: PosgreSQL Security Architecture
Next
From: Teodor Sigaev
Date:
Subject: Re: Test CMake build