Re: random_page_cost vs ssd?

From: Kevin Grittner
Subject: Re: random_page_cost vs ssd?
Date: ,
Msg-id: 49B7CD6B.EE98.0025.0@wicourts.gov
(view: Whole thread, Raw)
In response to: Re: random_page_cost vs ssd?  (Scott Carey)
Responses: Re: random_page_cost vs ssd?  (Scott Carey)
List: pgsql-performance

Tree view

random_page_cost vs ssd?  (Jeff, )
 Re: random_page_cost vs ssd?  (Grzegorz Jaśkiewicz, )
  Re: random_page_cost vs ssd?  (Scott Carey, )
   Re: random_page_cost vs ssd?  (Andrej, )
    Re: random_page_cost vs ssd?  (Scott Carey, )
     Re: random_page_cost vs ssd?  (hubert depesz lubaczewski, )
     Re: random_page_cost vs ssd?  ("Kevin Grittner", )
      Re: random_page_cost vs ssd?  (Scott Carey, )

Scott Carey <> wrote:
> On 3/11/09 11:04 AM, "Andrej" <> wrote:
>> 2009/3/12 Scott Carey <>:

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

From: Tom Lane
Date:
Subject: Re: Proposal of tunable fix for scalability of 8.4
From: Tom Lane
Date:
Subject: Re: Full statement logging problematic on larger machines?