Horton

Re: Out of Memory errors are frustrating as heck!

Gavin Flower <gavinflower@archidevsys.co.nz>

View thread View on postgr.es
From: Gavin Flower <GavinFlower@archidevsys.co.nz>
To: pgsql-performance@lists.postgresql.org
Date: 2019-04-17T07:53:16Z
Lists: pgsql-performance 
On 17/04/2019 18:01, Jean-David Beyer wrote:
> On 4/16/19 6:39 PM, Gavin Flower wrote:
>> I suspect that most things will run a little better with some swap space.
> Not always.
>
> $ free
>                total       used      free  shared   buffers     cached
> Mem:       16254616   13120960   3133656   20820    646676   10765380
> -/+ buffers/cache:     1708904  14545712
> Swap:       4095996      17436   4078560
>
Unclear what is the point you're trying to make, and the stats you quote 
don't enlighten me.

Commits

  1. Consider BufFiles when adjusting hashjoin parameters

  2. Allocate hash join files in a separate memory context