Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 98403631A2D for ; Wed, 11 Mar 2009 17:31:20 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 84869-09 for ; Wed, 11 Mar 2009 17:31:13 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from EXHUB018-3.exch018.msoutlookonline.net (exhub018-3.exch018.msoutlookonline.net [64.78.17.18]) by mail.postgresql.org (Postfix) with ESMTP id 513396336CA for ; Wed, 11 Mar 2009 17:31:16 -0300 (ADT) Received: from EXVMBX018-1.exch018.msoutlookonline.net ([64.78.17.47]) by EXHUB018-3.exch018.msoutlookonline.net ([64.78.17.18]) with mapi; Wed, 11 Mar 2009 13:31:14 -0700 From: Scott Carey To: Kevin Grittner CC: "gryzman@gmail.com" , "\"\"" <"">, "pgsql-performance@postgresql.org" , Jeff Date: Wed, 11 Mar 2009 13:31:13 -0700 Subject: Re: random_page_cost vs ssd? Thread-Topic: [PERFORM] random_page_cost vs ssd? Thread-Index: AcmigVDEMroQm3fOT32grIUdJY3uCwABwCI8 Message-ID: In-Reply-To: <49B7CD6B.EE98.0025.0@wicourts.gov> Accept-Language: en-US Content-Language: en X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: multipart/alternative; boundary="_000_C5DD6DA032FCscottrichrelevancecom_" MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=AWL=-0.000, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200903/103 X-Sequence-Number: 33025 --_000_C5DD6DA032FCscottrichrelevancecom_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Echo. It was a typo. On 3/11/09 11:40 AM, "Kevin Grittner" wrote: 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 --_000_C5DD6DA032FCscottrichrelevancecom_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Re: [PERFORM] random_page_cost vs ssd? Echo.  It was a typo.


On 3/11/09 11:40 AM, "Kevin Grittner" <Kevin.Grittner@wicourts.gov> wrote:

Scott Carey <scott@richrelevance.com> wrote:
> On 3/11/09 11:04 AM, "Andrej" <andrej.groups@gmail.com> wrote:
>> 2009/3/12 Scott Carey <scot= t@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:
> h= ttp://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 yo= ur
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 you= r
>> quotes concise.
>>
>> http:/= /www.american.edu/econ/notes/htmlmail.htm

Did you miss this part?

-Kevin

--_000_C5DD6DA032FCscottrichrelevancecom_--