Re: How i can empty the buffers of a db - Mailing list pgsql-general

From Josh Jore
Subject Re: How i can empty the buffers of a db
Date
Msg-id Pine.BSO.4.44.0208021023050.13961-100000@kitten.greentechnologist.org
Whole thread Raw
In response to Re: How i can empty the buffers of a db  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: How i can empty the buffers of a db  (Tourtounis Sotiris <tourtoun@csd.uoc.gr>)
List pgsql-general
On Fri, 2 Aug 2002, Tom Lane wrote:

> Josh Jore <josh@greentechnologist.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


pgsql-general by date:

Previous
From: "Michal Taborsky"
Date:
Subject: Re: Selecting random row
Next
From: Phil Dobbin
Date:
Subject: Re: Postgres and Perl: Which DBI module?