Re: How i can empty the buffers of a db

From: Josh Jore <josh(at)greentechnologist(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Tourtounis Sotiris <tourtoun(at)csd(dot)uoc(dot)gr>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: How i can empty the buffers of a db
Date: 2002-08-02 15:25:41
Message-ID: Pine.BSO.4.44.0208021023050.13961-100000@kitten.greentechnologist.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 2 Aug 2002, Tom Lane wrote:

> Josh Jore <josh(at)greentechnologist(dot)org> writes:
> > I take it you mean the shared memory buffer then[1]. You stop PostgreSQL.
>
> Probably a more interesting question is why would you want to? What
> is it you actually want to accomplish?

I don't know about you but I'm prepared to be fully boggled by people's
wishes for functionality. My only guess is that he wanted to avoid initial
use of cache or something. Maybe to watch disk io or something like that.
Anyhow, I suppose that also means just do the work directly after a fresh
boot to avoid the filesystem buffer cache as well. It's all very wacky.

Joshua b. Jore ; http://www.greentechnologist.org

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Eliel Mamousette 2002-08-02 15:29:04 Re: Any last hope advice?
Previous Message Phil Dobbin 2002-08-02 15:19:45 Re: Postgres and Perl: Which DBI module?