Re: Tons of free RAM. Can't make it go away.

From: Віталій Тимчишин <tivv00(at)gmail(dot)com>
To: sthomas(at)optionshouse(dot)com
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Tons of free RAM. Can't make it go away.
Date: 2012-10-28 03:49:25
Message-ID: CABWW-d37ut8uWFDvLrv9Pa9wwiX2425F3bn4cVJXwt-jj2pJRg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Sorry for late response, but may be you are still strugling.

It can be that some query(s) use a lot of work mem, either because of high
work_mem setting or because of planner error. In this case the moment query
runs it will need memory that will later be returned and become free.
Usually this can be seen as active memory spike with a lot of free memory
after.

2012/10/22 Shaun Thomas <sthomas(at)optionshouse(dot)com>

> Hey everyone!
>
> This is pretty embarrassing, but I've never seen this before. This is our
> system's current memory allocation from 'free -m':
>
> total used free buffers cached
> Mem: 72485 58473 14012 3 34020
> -/+ buffers/cache: 24449 48036
>
> So, I've got 14GB of RAM that the OS is just refusing to use for disk or
> page cache. Does anyone know what might cause that?
>
> Our uname -sir, for reference:
>
> Linux 3.2.0-31-generic x86_64
>
> --

--
Best regards,
Vitalii Tymchyshyn

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2012-10-28 15:06:21 Re: Prepared statements slow in 9.2 still (bad query plan)
Previous Message Pavel Stehule 2012-10-27 04:49:36 Re: Slower Performance on Postgres 9.1.6 vs 8.2.11