My first two guesses are ulimit or numa. numactl --hardware will show your how many nodes your box has and if you're exhausting any of them.
On Thu, Sep 20, 2018, 6:11 PM greigwise <greigw...@comcast.net> wrote: > Hello, I'm running postgres 9.6.10 on Centos 7. Seeing the occasional out > of memory error trying to run a query. In the logs I see something like > this: > > Grand total: 462104832 bytes in 795 blocks; 142439136 free (819860 chunks); > 319665696 used > 2018-09-20 18:08:01 UTC xxxx 5ba3e1a2.7a8a dbname ERROR: out of memory > 2018-09-20 18:08:01 UTC xxxx 5ba3e1a2.7a8a dbname DETAIL: Failed on > request > of size 2016. > > If I have 142439136 free, then why am I failing on a request of size 2016? > > Am I misunderstanding here? > > Thanks, > Greig Wise > > > > -- > Sent from: > http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html > >
