Search Postgresql Archives

Re: Out of Memory

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Tue, Sep 25, 2018 at 2:05 PM PT <wmoran@xxxxxxxxxxxxxxxxx> wrote:
On Tue, 25 Sep 2018 11:34:19 -0700 (MST)
greigwise <greigwise@xxxxxxxxxxx> wrote:

> Well, I've been unsuccessful so far on creating a standalone test.   
>
> I have put some scripting in place to capture some additional information on
> the server with the out of memory issues.   I have a script which just
> periodically dumps the output of free -m to a text file. 
>
> So, the output of free -m immediately before and after the out of memory
> error looks like this:
>
> Just before:
>               total        used        free      shared  buff/cache 
> available
> Mem:          14877        2978         132        3553       11766       
> 7943
> Swap:             0           0           0
>
> Just after:
>               total        used        free      shared  buff/cache 
> available
> Mem:          14877        2946         649        3548       11280       
> 7982
> Swap:             0           0           0
>
> If I have nearly 8 GB of memory left, why am I getting out of memory errors?

Doesn't the default NUMA setup mean that it can't actually allocate all
the available memory to a single NUMA zone (or whatever it's called)?

Or am I talking ancient Linux history with that?

--
Bill Moran

 
By the way we have similar issues running in our smaller stage environment.  9.5.6 on CentOS 7.2

Only ever my stage environment on smaller AWS t2 boxen. Memory looks fine but Postgres says it has no access to any. And my settings are really low.

Not sure if it's the same issue, but we run into it a few times a year in my stage environment. Also running postgres in unlimited mode for ulimit.

Tory

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux