Re: Out of memory with "create extension postgis"

2020-08-03 Thread Daniel Westermann (DWE)
>I am aware that the behavior is different from what we've seen last week but >this is how it looks today. >Anything we missed or did not do correct? Finally this can be re-produced quite easily by installing this extension: https://de.osdn.net/projects/pgstoreplans/downloads/72297/pg_store_plan

Re: Out of memory with "create extension postgis"

2020-08-03 Thread Daniel Westermann (DWE)
>> Here is a new one with bt at the end: >That's just showing the stack when the backend is idle waiting for input. >We need to capture the stack at the moment when the "out of memory" error >is reported (errfinish() should be the top of stack). Then I don't know what/how to do it. Here is a comp

Re: Out of memory with "create extension postgis"

2020-07-30 Thread Tom Lane
"Daniel Westermann (DWE)" writes: >> Umm ... you didn't issue a "bt" when you got to errfinish, so there's >> no useful info here. > Here is a new one with bt at the end: That's just showing the stack when the backend is idle waiting for input. We need to capture the stack at the moment when the

Re: Out of memory with "create extension postgis"

2020-07-30 Thread Daniel Westermann (DWE)
From: Tom Lane Sent: Wednesday, July 29, 2020 17:05 To: Daniel Westermann (DWE) Cc: pgsql-general@lists.postgresql.org Subject: Re: Out of memory with "create extension postgis"   "Daniel Westermann (DWE)" writes: >> So this is what we got today. In the log file the

Re: Out of memory with "create extension postgis"

2020-07-29 Thread Tom Lane
"Daniel Westermann (DWE)" writes: > So this is what we got today. In the log file there is this: > 2020-07-29 16:33:23 CEST 101995 ERROR:  out of memory > 2020-07-29 16:33:23 CEST 101995 DETAIL:  Failed on request of size 8265691 in > memory context "PortalContext". > 2020-07-29 16:33:23 CEST 10

Re: Out of memory with "create extension postgis"

2020-07-29 Thread Daniel Westermann (DWE)
"Daniel Westermann (DWE)" 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) >

Re: Out of memory with "create extension postgis"

2020-07-28 Thread Daniel Westermann (DWE)
>>> "Daniel Westermann (DWE)" 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

Re: Out of memory with "create extension postgis"

2020-07-28 Thread Tom Lane
"Daniel Westermann (DWE)" writes: >> "Daniel Westermann (DWE)" 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.

Re: Out of memory with "create extension postgis"

2020-07-28 Thread Daniel Westermann (DWE)
>"Daniel Westermann (DWE)" writes: >> we have a very strange behavior on PostgreSQL 12.3 when we try to create the >> extension postgis. Postgres and postgis have both been installed from >> packages: >> ... >> The process eats all the available memory and finally dies: >> # create extension pos

Re: Out of memory with "create extension postgis"

2020-07-28 Thread Tom Lane
"Daniel Westermann (DWE)" writes: > we have a very strange behavior on PostgreSQL 12.3 when we try to create the > extension postgis. Postgres and postgis have both been installed from > packages: > ... > The process eats all the available memory and finally dies: > # create extension postgis; >