From: Merlin Moncure <mmoncure@gmail.com>
To: Cédric Villemain <cedric.villemain.debian@gmail.com>
Cc: raghu ram <raghuchennuru@gmail.com>
Cc: Raghavendra <raghavendra.rao@enterprisedb.com>
Cc: Simon Riggs <simon@2ndquadrant.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Cc: pgsql-general <pgsql-general@postgresql.org>
Cc: pgsql novice <pgsql-novice@postgresql.org>
Subject: Re: [GENERAL] Can we Flush the Postgres Shared Memory ?
Date: Tue, 3 May 2011 09:08:35 -0500
Message-ID: <BANLkTim_LQ3oMVonYNX5-vbvw6d2A_M7vQ@mail.gmail.com> (raw)
In-Reply-To: <BANLkTi=DbF3=sU=ki3yTGH9Y=ZVK7tH5yA@mail.gmail.com>
References: <BANLkTikKE-iZQ3u_Voevgr2EpPFYjb2yng@mail.gmail.com>
<BANLkTikUYxYXUv-FsDQtN0CYiqkJ1BorXw@mail.gmail.com>
<BANLkTi=VtowCtuQTmjmnTiEk7mYAY8X2dw@mail.gmail.com>
<BANLkTinmZhDFg-PV5sztAYVLMm7Qm-+p7w@mail.gmail.com>
<BANLkTin1Vn82yDaALCVuH57NjjFurri73Q@mail.gmail.com>
<BANLkTi=DbF3=sU=ki3yTGH9Y=ZVK7tH5yA@mail.gmail.com>
On Tue, May 3, 2011 at 8:55 AM, Cédric Villemain
<cedric.villemain.debian@gmail.com> wrote:
> 2011/5/3 Merlin Moncure <mmoncure@gmail.com>:
>>
>> no it will not, or at least there is no guarantee it will be. the
>> only way to reset the buffers in that sense is to restart the database
>> (and even then they might not be read from disk, because they could
>> sit in the o/s cache). to force a read from the drive you'd have to
>> reboot the server, or at least shut it down and use a lot of memory
>> for some other purpose.
>
> with linux, you can : "echo 3 > /proc/sys/vm/drop_caches" for the OS cache
>
yeah -- good point. aside: does that also drop cache on the drive/raid card?
merlin
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: mmoncure@gmail.com, cedric.villemain.debian@gmail.com, raghuchennuru@gmail.com, raghavendra.rao@enterprisedb.com, simon@2ndquadrant.com, pgsql-general@postgresql.org, pgsql-novice@postgresql.org
Subject: Re: [GENERAL] Can we Flush the Postgres Shared Memory ?
In-Reply-To: <BANLkTim_LQ3oMVonYNX5-vbvw6d2A_M7vQ@mail.gmail.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