Re: [GENERAL] PostgreSQL Cache

2008-09-30 Thread Sam Mason
On Mon, Sep 29, 2008 at 05:53:02PM -0400, Greg Smith wrote: > On Mon, 29 Sep 2008, Sam Mason wrote: > > echo 3 | sudo tee /proc/sys/vm/drop_caches > >As an aside, it would be nicer if there was a more appropriate program > >than tee but I've yet to find one. > > What are you trying to accomplish

Re: [GENERAL] PostgreSQL Cache

2008-09-29 Thread Greg Smith
On Mon, 29 Sep 2008, Sam Mason wrote: On Mon, Sep 29, 2008 at 02:55:52AM -0400, Greg Smith wrote: 3) sudo echo 3 > /proc/sys/vm/drop_caches I'm not sure about the rest, but shouldn't this be: echo 3 | sudo tee /proc/sys/vm/drop_caches I couldn't think of any reason to actually include the

Re: [GENERAL] PostgreSQL Cache

2008-09-29 Thread Sam Mason
On Mon, Sep 29, 2008 at 02:55:52AM -0400, Greg Smith wrote: > On Mon, 29 Sep 2008, Matthew Pulis wrote: > >I need to perform some timed testing, thus need to make sure that > >disk cache does not affect me. Is clearing the OS (Ubuntu) disk > >cache, (by running: sudo echo 3 | sudo tee /proc/sys/vm/

Re: [GENERAL] PostgreSQL Cache

2008-09-29 Thread Oleg Bartunov
A while ago I wrote a script based on Dave Plonka work http://net.doit.wisc.edu/~plonka/fincore/ My script monitors system buffers and shared buffers (if pg_buffercache installed) and I found it's almost useless to check system buffers, since I got rather ridiculous numbers. I use it to inve

Re: [GENERAL] PostgreSQL Cache

2008-09-29 Thread Joris Dobbelsteen
Matthew Pulis wrote: Hi, I need to perform some timed testing, thus need to make sure that disk cache does not affect me. Is clearing the OS (Ubuntu) disk cache, ( by running: sudo echo 3 | sudo tee /proc/sys/vm/drop_caches ) enough to do this? If not can you please point me to some site ple

Re: [GENERAL] PostgreSQL Cache

2008-09-28 Thread Greg Smith
On Mon, 29 Sep 2008, Matthew Pulis wrote: I need to perform some timed testing, thus need to make sure that disk cache does not affect me. Is clearing the OS (Ubuntu) disk cache, ( by running: sudo echo 3 | sudo tee /proc/sys/vm/drop_caches ) enough to do this? What you should do is: 1) Shutd

[GENERAL] PostgreSQL Cache

2008-09-28 Thread Matthew Pulis
Hi, I need to perform some timed testing, thus need to make sure that disk cache does not affect me. Is clearing the OS (Ubuntu) disk cache, ( by running: sudo echo 3 | sudo tee /proc/sys/vm/drop_caches ) enough to do this? If not can you please point me to some site please since all I am finding