Re: Out of memory with "create extension postgis"

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Out of memory with "create extension postgis"
Дата
Msg-id 1183741.1595944647@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Out of memory with "create extension postgis"  ("Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com>)
Ответы Re: Out of memory with "create extension postgis"  ("Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com>)
Список pgsql-general
"Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com> writes:
> we have a very strange behavior on PostgreSQL 12.3 when we try to create the extension postgis. Postgres and postgis
haveboth been installed from packages: 
> ...
> The process eats all the available memory and finally dies:
> # create extension postgis;
> ERROR:  out of memory
> DETAIL:  Failed on request of size 8265691 in memory context "PortalContext".
> Time: 773569.877 ms (12:53.570)

Quite odd.  There should have been a memory context dump written to the
postmaster's stderr, can you show that?  Also possibly useful would be
a backtrace (set a breakpoint at errfinish):

https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend

            regards, tom lane



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

Предыдущее
От: Scott Ribe
Дата:
Сообщение: Re: is JIT available
Следующее
От: Shaozhong SHI
Дата:
Сообщение: Re: Issues of slow running queries when dealing with Big Data