Postgres Pro
Downloads
Home   >   mailing lists

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

From Enrico Pirozzi
Subject memory problem with refresh materialized view
Date
Msg-id CAEe=WwX+9g2mW2+qMQiKsMg7qvQMdiFLzGK0rVmbu_tvC-9RWA@mail.gmail.com
Whole thread Raw
Responses Re: memory problem with refresh materialized view  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-general
Tree view
Hi
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


Can anyone help me?

Thanks in advantage :)

Enrico

--
PostgreSQL openday Rimini 27-02-2016 

Enrico Pirozzi
Tel.  +39 0861 1855771 - Mob.+39 328 4164437 - Fax  +39 0861 1850310
http://www.pgtraining.com <http://www.pgtraining.com-> -
info@pgtraining.com
www.enricopirozzi.info - info@enricopirozzi.info
Skype sscotty71 - Gtalk sscotty71@gmail.com

pgsql-general by date:

Previous
From: Yury Zhuravlev
Date:
Subject: Re: Test CMake build
Next
From: Yury Zhuravlev
Date:
Subject: Re: Test CMake build