Re: Out of Memory errors are frustrating as heck!

Gavin Flower <[email protected]>
Newsgroups gmane.comp.db.postgresql.performance
Organization ArchiDevSys
Message-ID <[email protected]>
On 15/04/2019 08:23, Gunther wrote:
>
> For weeks now, I am banging my head at an "out of memory" situation. 
> There is only one query I am running on an 8 GB system, whatever I 
> try, I get knocked out on this out of memory. It is extremely 
> impenetrable to understand and fix this error. I guess I could add a 
> swap file, and then I would have to take the penalty of swapping. But 
> how can I actually address an out of memory condition if the system 
> doesn't tell me where it is happening?
>
[...]

I strongly suigest having a swap file, I've got 32GB, and I've used 
2.9GB of my swap space after 4 days, but I'm not really pushing my 
system.  For me, mostly stuff that is only used once, or not at all, is 
swapped out.  If you do have a memory leak, then it might be easier to 
diagnose, if you don't run out on Memory.

I suspect that most things will run a little better with some swap space.


Cherers,
Gavin
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.