Re: random_page_cost vs ssd? - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: random_page_cost vs ssd?
Date
Msg-id 49B7CD6B.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Re: random_page_cost vs ssd?  (Scott Carey <scott@richrelevance.com>)
Responses Re: random_page_cost vs ssd?  (Scott Carey <scott@richrelevance.com>)
List pgsql-performance
Scott Carey <scott@richrelevance.com> wrote:
> On 3/11/09 11:04 AM, "Andrej" <andrej.groups@gmail.com> wrote:
>> 2009/3/12 Scott Carey <scott@richrelevance.com>:

>>> All tests start with 'cat 3 > /proc/sys/vm/drop_caches'

>> What's the content of '3' above?

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

The cited page recommends "echo 3" -- is that what you used in your
tests, or the "cat 3" you repeated specify?  If the latter, what is in
the "3" file?

>> Please don't top post, and don't use HTML e-Mail :}  Make your
>> quotes concise.
>>
>> http://www.american.edu/econ/notes/htmlmail.htm

Did you miss this part?

-Kevin

pgsql-performance by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: random_page_cost vs ssd?
Next
From: Scott Marlowe
Date:
Subject: Re: Full statement logging problematic on larger machines?