Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 27C70632AAF for ; Wed, 11 Mar 2009 12:38:01 -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 14614-05 for ; Wed, 11 Mar 2009 12:37:58 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-bw0-f170.google.com (mail-bw0-f170.google.com [209.85.218.170]) by mail.postgresql.org (Postfix) with ESMTP id CC627632662 for ; Wed, 11 Mar 2009 12:37:57 -0300 (ADT) Received: by bwz18 with SMTP id 18so74353bwz.19 for ; Wed, 11 Mar 2009 08:37:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=Q00+UPbGlRX4ibaBMGDX/6dkh81Sf8hwWW73DK4a2sk=; b=ra6R3tnTcKA7zBC2BVU2lJNmpirsYJ2vmgJPDPM7ih1z5rdosCk8aVXYOYxEX4yv98 R39MOuqIWwpCpDufOiUbr0wsrzCKMtvSs2vBuIIhJjAdmSoSo5nlrUYv90+2+3Mu4enj kyrJm1E4Qdgyy3Ab67T2PhdKF2u8L0r+4O+QU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=jPz1kT1zJxOUP4Lw0RrvCUsl6QXd7RFxkV/0DJl0KrQSq49rPUsyHi1sGOcQBH7dMX OGcYLXnmzCSnIDpwol8dK0zJZxODX5isUI55jKYt4Su+eMWHW2aiP7UfAZAou9NDN+0K zZGdPevP2AsQ0S4SqsWVlSGCTy0EfT1+p2Yb0= MIME-Version: 1.0 Received: by 10.223.110.211 with SMTP id o19mr6484189fap.57.1236785875930; Wed, 11 Mar 2009 08:37:55 -0700 (PDT) In-Reply-To: References: Date: Wed, 11 Mar 2009 15:37:55 +0000 Message-ID: <2f4958ff0903110837x21aa4c75m4473d053127c043d@mail.gmail.com> Subject: Re: random_page_cost vs ssd? From: =?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= To: Jeff Cc: pgsql-performance@postgresql.org Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200903/95 X-Sequence-Number: 33017 On Wed, Mar 11, 2009 at 1:46 PM, Jeff wrote: > I've got a couple x25-e's in production now and they are working like a > champ. =C2=A0(In fact, I've got another box being built with all x25s in = it. its > going to smoke!) > > Anyway, I was just reading another thread on here and that made me wonder > about random_page_cost in the world of an ssd where a seek is basically > free. =C2=A0I haven't tested this yet (I can do that next week), but logi= cally, > in this scenario wouldn't lowering random_page_cost be ideal or would it = not > really matter in the grand scheme of things? Just on a side note, random access on SSD is still more expensive than sequential, because it is designed in banks. If you don believe me, turn off any software/OS cache , and try random access timing against seq reads. This gap is just much much narrower. --=20 GJ