memory problem with refresh materialized view

[Enrico Pirozzi <sscotty71@xxxxxxxxx>]

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@xxxxxxxxxxxxxx
www.enricopirozzi.info - info@xxxxxxxxxxxxxxxxxx
Skype sscotty71 - Gtalk sscotty71@xxxxxxxxx