Re: random_page_cost vs ssd?

From: Scott Carey <scott(at)richrelevance(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: "gryzman(at)gmail(dot)com" <gryzman(at)gmail(dot)com>, "\"<Andrej <andrej(dot)groups(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 20:31:13
Message-ID: C5DD6DA0.32FC%scott@richrelevance.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Echo. It was a typo.

On 3/11/09 11:40 AM, "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:

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

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2009-03-11 20:46:10 Re: Full statement logging problematic on larger machines?
Previous Message Scott Marlowe 2009-03-11 19:41:24 Re: Full statement logging problematic on larger machines?