Re: memory problem with refresh materialized view

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: memory problem with refresh materialized view
Дата
Msg-id A737B7A37273E048B164557ADEF4A58B537F7EEA@ntex2010i.host.magwien.gv.at
обсуждение исходный текст
Ответ на memory problem with refresh materialized view  (Enrico Pirozzi <sscotty71@gmail.com>)
Ответы PostgreSQL 9.5 and process REST calls enquiry  (Peter van Eck <peter@vaneckzone.net>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Albe Laurenz
Дата:
Сообщение: Re: PosgreSQL Security Architecture
Следующее
От: Teodor Sigaev
Дата:
Сообщение: Re: Test CMake build