From: Kevin Grittner <kgrittn@ymail.com>
To: AL-Temimi, Muthana <muthana.al-temimi@tu-harburg.hamburg.de>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Cached Memory increasing up and drop the caches through sync; echo 1 > /proc/sys/vm/drop_caches
Date: Mon, 6 Jul 2015 15:37:26 +0000 (UTC)
Message-ID: <23816193.2878261.1436197046286.JavaMail.yahoo@mail.yahoo.com> (raw)
In-Reply-To: <24F2E095E199B041912675E4E3BBA011BA48E164@WEXCPPA018.fhhnet.stadt.hamburg.de>
References: <24F2E095E199B041912675E4E3BBA011BA48E164@WEXCPPA018.fhhnet.stadt.hamburg.de>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
"AL-Temimi, Muthana" <muthana.al-temimi@tu-harburg.hamburg.de>
wrote:
> is there any problem if I use the following command:
> “sync; echo 1 > /proc/sys/vm/drop_caches”
> to release the cached memory on linux server.
The only problem would be that performance would tend to be poor if
you discard the OS cache.
> Because I have a problem with cached memory on the linux Server
> beacaue there are increasing in cached memory till swap.
You probably have not configured PostgreSQL very well. Please
describe your hardware and OS and show the results of running these
queries:
SELECT version();
SELECT name, current_setting(name), SOURCE
FROM pg_settings
WHERE SOURCE NOT IN ('default', 'override');
Also, if you could show about 30 seconds of output from `vmstat 1`
while the swapping is happening, that would help us provide useful
advice.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: kgrittn@ymail.com, muthana.al-temimi@tu-harburg.hamburg.de
Subject: Re: Cached Memory increasing up and drop the caches through sync; echo 1 > /proc/sys/vm/drop_caches
In-Reply-To: <23816193.2878261.1436197046286.JavaMail.yahoo@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox