From: Scott Carey <scott@richrelevance.com>
To: Andrej <andrej.groups@gmail.com>
Cc: Grzegorz Jaśkiewicz <gryzman@gmail.com>
Cc: Jeff <threshar@torgo.978.org>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: random_page_cost vs ssd?
Date: Wed, 11 Mar 2009 12:28:56 -0700
Message-ID: <C5DD5F07.32E1%scott@richrelevance.com> (raw)
In-Reply-To: <b35603930903111204l6825f931kf67183f7c48971fe@mail.gmail.com>
Google > “linux drop_caches” first result:
http://www.linuxinsight.com/proc_sys_vm_drop_caches.html
To be sure a test is going to disk and not file system cache for everything in linux, run:
‘sync; cat 3 > /proc/sys/vm/drop_caches’
On 3/11/09 11:04 AM, "Andrej" <andrej.groups@gmail.com> wrote:
2009/3/12 Scott Carey <scott@richrelevance.com>:
> [...snip...]. All tests start with 'cat 3 > /proc/sys/vm/drop_caches', and work on
> a 32GB data set (40% of the disk).
What's the content of '3' above?
--
Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.
http://www.american.edu/econ/notes/htmlmail.htm
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: scott@richrelevance.com, andrej.groups@gmail.com, gryzman@gmail.com, threshar@torgo.978.org
Subject: Re: random_page_cost vs ssd?
In-Reply-To: <C5DD5F07.32E1%scott@richrelevance.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox