Re: random_page_cost vs ssd?

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Scott Carey" <scott(at)richrelevance(dot)com>
Cc: <gryzman(at)gmail(dot)com>,<Andrej <andrej(dot)groups(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>, "Jeff" <threshar(at)torgo(dot)978(dot)org>
Subject: Re: random_page_cost vs ssd?
Date: 2009-03-11 19:40:44
Message-ID: 49B7CD6B.EE98.0025.0@wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Scott Carey <scott(at)richrelevance(dot)com> wrote:
> On 3/11/09 11:04 AM, "Andrej" <andrej(dot)groups(at)gmail(dot)com> wrote:
>> 2009/3/12 Scott Carey <scott(at)richrelevance(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2009-03-11 19:41:24 Re: Full statement logging problematic on larger machines?
Previous Message hubert depesz lubaczewski 2009-03-11 19:32:27 Re: random_page_cost vs ssd?