pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Gunther <raj@gusw.net>
Cc: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: Justin Pryzby <pryzby@telsasoft.com>
Cc: Jeff Janes <jeff.janes@gmail.com>
Cc: pgsql-performance@lists.postgresql.org, Alvaro Herrera <alvherre@2ndquadrant.com>
Subject: Re: Out of Memory errors are frustrating as heck!
Date: Fri, 23 Aug 2019 10:20:31 -0400
Message-ID: <26356.1566570031@sss.pgh.pa.us> (raw)
In-Reply-To: <7ed3d2a0-0a1d-0bd2-5417-9b69038abfcf@gusw.net>
References: <20190421161434.4hedytsadpbnglgk@development>
	<19198.1555857403@sss.pgh.pa.us>
	<20190421164022.GD14223@telsasoft.com>
	<20190422030927.3huxq7gghms4kmf4@development>
	<2d422e7e-3105-3320-f3d5-801bd6a8b27d@gusw.net>
	<20190423204348.GJ3925@telsasoft.com>
	<f61f61d1-fbd6-2bbd-a4b9-7591ad18dde5@gusw.net>
	<20190424003633.ruvhbv5ro3fawo67@development>
	<20190428141901.5dsbge2ka3rxmpk6@development>
	<7ed3d2a0-0a1d-0bd2-5417-9b69038abfcf@gusw.net>

Gunther <raj@gusw.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





view thread (8+ messages)  latest in thread

Message-ID: <26356.1566570031@sss.pgh.pa.us>
Permalink:  ../26356.1566570031@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/26356.1566570031@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tgl@sss.pgh.pa.us, raj@gusw.net, tomas.vondra@2ndquadrant.com, pryzby@telsasoft.com, jeff.janes@gmail.com, alvherre@2ndquadrant.com
  Subject: Re: Out of Memory errors are frustrating as heck!
  In-Reply-To: <26356.1566570031@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox