Horton

Re: Out of Memory errors are frustrating as heck!

Gaetano Mendola <mendola@gmail.com>

View thread View on postgr.es
From: Gaetano Mendola <mendola@gmail.com>
To: Gunther <raj@gusw.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Alvaro Herrera <alvherre@2ndquadrant.com>, Jeff Janes <jeff.janes@gmail.com>, Tomas Vondra <tomas.vondra@2ndquadrant.com>, pgsql-performance@lists.postgresql.org, Justin Pryzby <pryzby@telsasoft.com>
Date: 2019-04-19T20:28:38Z
Lists: pgsql-performance 
On Thu, Apr 18, 2019 at 6:01 AM Gunther <raj@gusw.net> wrote:

> Hi guys. I don't want to be pushy, but I found it strange that after so
> much lively back and forth getting to the bottom of this, suddenly my last
> nights follow-up remained completely without reply. I wonder if it even got
> received. For those who read their emails with modern readers (I know I too
> am from a time where I wrote everything in plain text) I marked some
> important questions in bold.
>

Give Tom Lane remote access to your server, around 10 years ago I had the
server crashing and the fastest we could do is let him access the server.

G.

Commits

  1. Consider BufFiles when adjusting hashjoin parameters

  2. Allocate hash join files in a separate memory context