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
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
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
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