[GENERAL] How to clear linux file cache?

2004-11-16 Thread Janning Vygen
Hi, i am testing a few queries in my postgresql DB. The first query after reboot is always slower because of an empty OS page/file cache. I want to test my queries without any files in the linux kernel cache, just to know what would be the worst execution time. At the moment i stop postgresql

Re: [GENERAL] How to clear linux file cache?

2004-11-16 Thread Doug McNaught
Janning Vygen [EMAIL PROTECTED] writes: So how do i easily empty all page/file caches on linux (2.4.24)? Probably the closest you can easily get is to put the Postgres data files on their own partition, and unmount/remount that partition before running yuour tests. Unmounting will sync and

Re: [GENERAL] How to clear linux file cache?

2004-11-16 Thread Janning Vygen
Am Dienstag, 16. November 2004 16:39 schrieb Doug McNaught: Janning Vygen [EMAIL PROTECTED] writes: So how do i easily empty all page/file caches on linux (2.4.24)? Probably the closest you can easily get is to put the Postgres data files on their own partition, and unmount/remount that

Re: [GENERAL] How to clear linux file cache?

2004-11-16 Thread Christopher Browne
The world rejoiced as [EMAIL PROTECTED] (Janning Vygen) wrote: So how do i easily empty all page/file caches on linux (2.4.24)? You can empty them of PostgreSQL-related data by filling them with something else. You might head to some directory that has more data in it than you have memory, and