| From: | Enrico Pirozzi <sscotty71(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | memory problem with refresh materialized view |
| Date: | 2016-02-11 12:11:43 |
| Message-ID: | CAEe=WwX+9g2mW2+qMQiKsMg7qvQMdiFLzGK0rVmbu_tvC-9RWA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
<http://www.postgresql.org/about/event/1861/>
Enrico Pirozzi
Tel. +39 0861 1855771 - Mob.+39 328 4164437 - Fax +39 0861 1850310
http://www.pgtraining.com <http://www.pgtraining.com-> -
info(at)pgtraining(dot)com
www.enricopirozzi.info - info(at)enricopirozzi(dot)info
Skype sscotty71 - Gtalk sscotty71(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kaushal Shriyan | 2016-02-11 12:16:17 | Unrecognized configuration parameter in bdr 0.9.3 |
| Previous Message | Yury Zhuravlev | 2016-02-11 12:09:35 | Re: Test CMake build |