Re: Out of Memory errors are frustrating as heck!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gunther <raj(at)gusw(dot)net>
Cc: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, Justin Pryzby <pryzby(at)telsasoft(dot)com>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, pgsql-performance(at)lists(dot)postgresql(dot)org, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Subject: Re: Out of Memory errors are frustrating as heck!
Date: 2019-08-23 14:20:31
Message-ID: 26356.1566570031@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Gunther <raj(at)gusw(dot)net> writes:
> Hi all, I am connecting to a discussion back from April this year. My
> data has grown and now I am running into new out of memory situations.

It doesn't look like this has much of anything to do with the hash-table
discussion. The big hog is an ExprContext:

> ExprContext: 1107296256 total in 142 blocks; 6328 free (101 chunks);
> 1107289928 used

So there's something leaking in there, but this isn't enough info
to guess what.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message andy andy 2019-08-24 03:24:47 pg_basebackup is taking an unusually long time with Postgres 11.3
Previous Message Gunther 2019-08-23 14:19:51 Re: Out of Memory errors are frustrating as heck!