Received: from maia.hub.org (maia-4.hub.org [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 7C613632CBB for ; Thu, 29 Apr 2010 16:25:18 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 66702-06 for ; Thu, 29 Apr 2010 19:25:10 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gw0-f46.google.com (mail-gw0-f46.google.com [74.125.83.46]) by mail.postgresql.org (Postfix) with ESMTP id A7E0F6329E5 for ; Thu, 29 Apr 2010 16:25:10 -0300 (ADT) Received: by gwj19 with SMTP id 19so5760138gwj.19 for ; Thu, 29 Apr 2010 12:25:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:cc:content-type; bh=+7xgMlqL0F4y/SiWZg9nNBOArCCybdoUKsasQJcIn8I=; b=sKPItYrtQqFgrwgZYUxOTVQQJWuowgFENVsPws+a8m5vL1eac/reTJjkSqguoCQ+fm AeJvbFOzscShKbRoJZ/wC6IKdpjYTRULZAiAJ1mJueRHfGrIsMVkpwsK2MOQqY8F+d86 zfBJPpigGbqthDi+wQ7SH3DPs1+ihov8ICrj8= 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; b=Pimlq6S+tpTygilIJ2+ZEewoPcVv01mkttyrpv6tebhQojaUl+6Z5BtZOwww1DeIpU bASDssS9SORZa1wVbzqcCDQdDFqWgBGkDHbbkxpaWrDRdcG/yZVaE7lwHrPS9oorJrjr 7yvzwbRrpp9gJfVOnneR4s0a/y91Mc0deryWI= MIME-Version: 1.0 Received: by 10.150.194.7 with SMTP id r7mr1921121ybf.226.1272569106337; Thu, 29 Apr 2010 12:25:06 -0700 (PDT) Received: by 10.150.134.20 with HTTP; Thu, 29 Apr 2010 12:25:06 -0700 (PDT) In-Reply-To: References: <4BD8DCEA.2020003@2ndquadrant.com> <4BD9198E.904@2ndquadrant.com> Date: Thu, 29 Apr 2010 13:25:06 -0600 Message-ID: Subject: Re: more 10K disks or less 15K disks From: Scott Marlowe To: Anj Adu Cc: Greg Smith , pgsql-admin@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001 X-Spam-Level: X-Archive-Number: 201004/353 X-Sequence-Number: 34447 On Thu, Apr 29, 2010 at 11:26 AM, Anj Adu wrote: > All the disks are usually laid out in a single RAID 10 stripe . There > are no dedicated disks for the OS/WAL as storage is a premium You should at least investigate the performance difference of having a separate volume for WAL files on your system. Since WAL files are mostly sequential, and db access is generally random, the WAL files can run really quickly on a volume that does nothing else but handle WAL writes sequentially. Given the volume you're handling, I would expect that storage is not any more important than performance. The fact that you're asking whether to go with 12 or 24 600G disks shows that you're willing to give up a little storage for performance. I would bet that the 24 10k disks with one pair dedicated for OS / pg_xlog would be noticeably faster than any single large volume config you'd care to test, especially for lots of active connections.