Re: How i can empty the buffers of a db

I am sorry for my lack of good knowledge of English but i have previously
asked how during a session with the database server to empty the memory
buffers after any commited select/insert/delete in order to have an as
much as possible indicative execution time and explain facility for each
of them. Thank you for your willingness of help !!!

SWTHRHS TOYRTOYNHS
(tourtoun(at)csd(dot)uch(dot)gr)

On Fri, 2 Aug 2002, Josh Jore wrote:

> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>