| From: | Janning Vygen <vygen(at)gmx(dot)de> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | How to clear linux file cache? |
| Date: | 2004-11-16 09:59:45 |
| Message-ID: | 200411161059.46156.vygen@gmx.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
and do something like
find / -name foo
for a few minutes and start postgresql afterwards.
I search manuals with "apropos page cache" and found sync but it doesnt clear
the cache, just writes dirty pages back to disk. I googled for "linux clear
page cache" but did not found what i need. (of course i searched the
archives, too)
So how do i easily empty all page/file caches on linux (2.4.24)?
Sorry for beeing a little bit OT, but i think my question still relates to
postgresql.
kind regards,
janning
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2004-11-16 10:11:32 | Re: OID's |
| Previous Message | Michael Glaesemann | 2004-11-16 09:52:40 | Re: OID's |