Re: Out of memory with "create extension postgis" - Mailing list pgsql-general

From Daniel Westermann (DWE)
Subject Re: Out of memory with "create extension postgis"
Date
Msg-id ZR0P278MB0122C24D9DEE78F10A336287D2730@ZR0P278MB0122.CHEP278.PROD.OUTLOOK.COM
Whole thread Raw
In response to Re: Out of memory with "create extension postgis"  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Out of memory with "create extension postgis"
List pgsql-general
>>> "Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com> writes:
>>>> 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)

>> There is nothing in the log file except these (not from today, but the messages are always the same):
>> 2020-07-03 16:52:16 CEST 53617 LOG:  server process (PID 54070) was terminated by signal 9: Killed

>A process that was killed by the OOM killer would not have managed to
>produce an "out of memory" ERROR report, so these two are different
>symptoms.  You need to reproduce the first case, or you won't have
>any luck setting an error breakpoint either.

You're right, that was before we adjusted the oom behavior. Will get back once I have more information.

Regards
Daniel

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Out of memory with "create extension postgis"
Next
From: Michael Lewis
Date:
Subject: Re: Issues of slow running queries when dealing with Big Data