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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
