From: | Paul Carlucci <paul(dot)carlucci(at)gmail(dot)com> |
---|---|
To: | greigwise <greigwise(at)comcast(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Out of Memory |
Date: | 2018-09-20 22:16:28 |
Message-ID: | CAKhGwmAqvY9BnJq1N6MpgWsYaVQatcwCw5h5yP0gs_XVL6tOWg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 <greigwise(at)comcast(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | greigwise | 2018-09-20 22:22:04 | Re: Out of Memory |
Previous Message | greigwise | 2018-09-20 22:11:32 | Out of Memory |