Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id B111E633264 for ; Wed, 11 Mar 2009 16:29:02 -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 71217-04 for ; Wed, 11 Mar 2009 16:28:54 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from EXHUB018-1.exch018.msoutlookonline.net (exhub018-1.exch018.msoutlookonline.net [64.78.17.16]) by mail.postgresql.org (Postfix) with ESMTP id D3DC8632B7F for ; Wed, 11 Mar 2009 16:28:57 -0300 (ADT) Received: from EXVMBX018-1.exch018.msoutlookonline.net ([64.78.17.47]) by EXHUB018-1.exch018.msoutlookonline.net ([64.78.17.16]) with mapi; Wed, 11 Mar 2009 12:28:56 -0700 From: Scott Carey To: Andrej CC: =?utf-8?B?R3J6ZWdvcnogSmHFm2tpZXdpY3o=?= , Jeff , "pgsql-performance@postgresql.org" Date: Wed, 11 Mar 2009 12:28:56 -0700 Subject: Re: random_page_cost vs ssd? Thread-Topic: [PERFORM] random_page_cost vs ssd? Thread-Index: AcmifDHEvoWhVWEdS5y8XjuV+NjAqAAA2wZl Message-ID: In-Reply-To: Accept-Language: en-US Content-Language: en X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: multipart/alternative; boundary="_000_C5DD5F0732E1scottrichrelevancecom_" 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/99 X-Sequence-Number: 33021 --_000_C5DD5F0732E1scottrichrelevancecom_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 R29vZ2xlID4g4oCcbGludXggZHJvcF9jYWNoZXPigJ0gZmlyc3QgcmVzdWx0Og0KaHR0cDovL3d3 dy5saW51eGluc2lnaHQuY29tL3Byb2Nfc3lzX3ZtX2Ryb3BfY2FjaGVzLmh0bWwNCg0KVG8gYmUg c3VyZSBhIHRlc3QgaXMgZ29pbmcgdG8gZGlzayBhbmQgbm90IGZpbGUgc3lzdGVtIGNhY2hlIGZv ciBldmVyeXRoaW5nIGluIGxpbnV4LCBydW46DQrigJhzeW5jOyBjYXQgMyA+IC9wcm9jL3N5cy92 bS9kcm9wX2NhY2hlc+KAmQ0KDQpPbiAzLzExLzA5IDExOjA0IEFNLCAiQW5kcmVqIiA8YW5kcmVq Lmdyb3Vwc0BnbWFpbC5jb20+IHdyb3RlOg0KDQoyMDA5LzMvMTIgU2NvdHQgQ2FyZXkgPHNjb3R0 QHJpY2hyZWxldmFuY2UuY29tPjoNCj4gWy4uLnNuaXAuLi5dLiAgICBBbGwgdGVzdHMgc3RhcnQg d2l0aCAnY2F0IDMgPiAvcHJvYy9zeXMvdm0vZHJvcF9jYWNoZXMnLCBhbmQgd29yayBvbg0KPiAg YSAzMkdCIGRhdGEgc2V0ICg0MCUgb2YgdGhlIGRpc2spLg0KV2hhdCdzIHRoZSBjb250ZW50IG9m ICczJyBhYm92ZT8NCg0KLS0NClBsZWFzZSBkb24ndCB0b3AgcG9zdCwgYW5kIGRvbid0IHVzZSBI VE1MIGUtTWFpbCA6fSAgTWFrZSB5b3VyIHF1b3RlcyBjb25jaXNlLg0KDQpodHRwOi8vd3d3LmFt ZXJpY2FuLmVkdS9lY29uL25vdGVzL2h0bWxtYWlsLmh0bQ0KDQo= --_000_C5DD5F0732E1scottrichrelevancecom_ Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: base64 PEhUTUw+DQo8SEVBRD4NCjxUSVRMRT5SZTogW1BFUkZPUk1dIHJhbmRvbV9wYWdlX2Nvc3QgdnMg c3NkPzwvVElUTEU+DQo8L0hFQUQ+DQo8Qk9EWT4NCjxGT05UIEZBQ0U9IkNhbGlicmksIFZlcmRh bmEsIEhlbHZldGljYSwgQXJpYWwiPjxTUEFOIFNUWUxFPSdmb250LXNpemU6MTFwdCc+R29vZ2xl ICZndDsgJiM4MjIwO2xpbnV4IGRyb3BfY2FjaGVzJiM4MjIxOyBmaXJzdCByZXN1bHQ6PEJSPg0K PGEgaHJlZj0iaHR0cDovL3d3dy5saW51eGluc2lnaHQuY29tL3Byb2Nfc3lzX3ZtX2Ryb3BfY2Fj aGVzLmh0bWwiPmh0dHA6Ly93d3cubGludXhpbnNpZ2h0LmNvbS9wcm9jX3N5c192bV9kcm9wX2Nh Y2hlcy5odG1sPC9hPjxCUj4NCjxCUj4NClRvIGJlIHN1cmUgYSB0ZXN0IGlzIGdvaW5nIHRvIGRp c2sgYW5kIG5vdCBmaWxlIHN5c3RlbSBjYWNoZSBmb3IgZXZlcnl0aGluZyBpbiBsaW51eCwgcnVu OjxCUj4NCiYjODIxNjtzeW5jOyBjYXQgMyAmZ3Q7IC9wcm9jL3N5cy92bS9kcm9wX2NhY2hlcyYj ODIxNzs8QlI+DQo8QlI+DQpPbiAzLzExLzA5IDExOjA0IEFNLCAmcXVvdDtBbmRyZWomcXVvdDsg Jmx0OzxhIGhyZWY9ImFuZHJlai5ncm91cHNAZ21haWwuY29tIj5hbmRyZWouZ3JvdXBzQGdtYWls LmNvbTwvYT4mZ3Q7IHdyb3RlOjxCUj4NCjxCUj4NCjwvU1BBTj48L0ZPTlQ+PEJMT0NLUVVPVEU+ PEZPTlQgRkFDRT0iQ2FsaWJyaSwgVmVyZGFuYSwgSGVsdmV0aWNhLCBBcmlhbCI+PFNQQU4gU1RZ TEU9J2ZvbnQtc2l6ZToxMXB0Jz4yMDA5LzMvMTIgU2NvdHQgQ2FyZXkgJmx0OzxhIGhyZWY9InNj b3R0QHJpY2hyZWxldmFuY2UuY29tIj5zY290dEByaWNocmVsZXZhbmNlLmNvbTwvYT4mZ3Q7OjxC Uj4NCiZndDsgWy4uLnNuaXAuLi5dLiAmbmJzcDsmbmJzcDsmbmJzcDtBbGwgdGVzdHMgc3RhcnQg d2l0aCAnY2F0IDMgJmd0OyAvcHJvYy9zeXMvdm0vZHJvcF9jYWNoZXMnLCBhbmQgd29yayBvbjxC Uj4NCiZndDsgJm5ic3A7YSAzMkdCIGRhdGEgc2V0ICg0MCUgb2YgdGhlIGRpc2spLjxCUj4NCldo YXQncyB0aGUgY29udGVudCBvZiAnMycgYWJvdmU/PEJSPg0KPEJSPg0KLS08QlI+DQpQbGVhc2Ug ZG9uJ3QgdG9wIHBvc3QsIGFuZCBkb24ndCB1c2UgSFRNTCBlLU1haWwgOn0gJm5ic3A7TWFrZSB5 b3VyIHF1b3RlcyBjb25jaXNlLjxCUj4NCjxCUj4NCjxhIGhyZWY9Imh0dHA6Ly93d3cuYW1lcmlj YW4uZWR1L2Vjb24vbm90ZXMvaHRtbG1haWwuaHRtIj5odHRwOi8vd3d3LmFtZXJpY2FuLmVkdS9l Y29uL25vdGVzL2h0bWxtYWlsLmh0bTwvYT48QlI+DQo8QlI+DQo8L1NQQU4+PC9GT05UPjwvQkxP Q0tRVU9URT4NCjwvQk9EWT4NCjwvSFRNTD4NCg0K --_000_C5DD5F0732E1scottrichrelevancecom_--