| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Daniel Westermann (DWE)" <daniel(dot)westermann(at)dbi-services(dot)com> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Out of memory with "create extension postgis" |
| Date: | 2020-07-30 15:17:57 |
| Message-ID: | 1427937.1596122277@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Daniel Westermann (DWE)" <daniel(dot)westermann(at)dbi-services(dot)com> 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 "out of memory" error
is reported (errfinish() should be the top of stack).
>> libraries to have gotten linked into a Postgres backend. What
>> extensions are you using?
> These are the extensions in use:
> plpythonu | 1.0 | pg_catalog | PL/PythonU untrusted procedural language
Hm. If you've been actively using plpython in this session, perhaps
libpython would have pulled all this other weirdness in with it.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Argha Deep Ghoshal | 2020-07-30 15:59:26 | Re: PSQLException: An I/O error occurred while sending to the backend. |
| Previous Message | Pavel Stehule | 2020-07-30 15:10:02 | Re: How to find out why user processes are using so much memory? |