Re: cache Memory of server

Am 2015-06-08 15:53, schrieb AL-Temimi, Muthana:
> See the free command:
>
> am 08.06.2015 um 15:13 Uhr: --active connection: 305
>
> srvpgsql1:/opt/pgsql_data # free
>
>  total used free shared buffers cached
>
> Mem: 12199684 8758400 3441284 1269784 231324 7139400
>
> -/+ buffers/cache: 1387676 10812008
>
> Swap: 6289404 0 6289404
>
>
> ----------------------------------------------------------------------
>
>
> am 08.06.2015 um 15:53 Uhr: --active connection: 278
>
> srvpgsql1:/opt/pgsql_data # free
>
>  total used free shared buffers cached
>
> Mem: 12199684 8686228 3513456 1269784 232164 7164288
>
> -/+ buffers/cache: 1289776 10909908
>
> Swap: 6289404 0 6289404
>


That is basically what Scott said: you are watching the Kernel FS
cache. It may only be a coincidence that it increased together with the
postgres sessions. A high number here is usually somehting good, because
a lot of your filesystems reads will be served from RAM. Looking at your
numbers, I would say you are "all good" (except as Scott said, mabye try
to reduce number of parallel sessions) - big fs cache and still free
RAM.
What are your settings for shared buffers btw?

Jan