X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C64A65E46D5 for ; Tue, 17 Aug 2004 12:50:38 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 36212-05 for ; Tue, 17 Aug 2004 15:50:43 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 7EB1A5E40BB for ; Tue, 17 Aug 2004 12:50:35 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i7HFogxd005038; Tue, 17 Aug 2004 11:50:42 -0400 (EDT) To: cgg007@yahoo.com Cc: pgsql-admin@postgresql.org Subject: Re: What's the best way to use a Solid State HDD? In-reply-to: <20040817144828.51558.qmail@web13807.mail.yahoo.com> References: <20040817144828.51558.qmail@web13807.mail.yahoo.com> Comments: In-reply-to Chris Gamache message dated "Tue, 17 Aug 2004 07:48:28 -0700" Date: Tue, 17 Aug 2004 11:50:42 -0400 Message-ID: <5037.1092757842@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0 tests=MAILTO_TO_SPAM_ADDR X-Spam-Level: * X-Archive-Number: 200408/144 X-Sequence-Number: 14539 Chris Gamache writes: > What would you do if you had a solid state hdd to use and you wanted > to speed up PostgreSQL? "Put WAL on it" is certainly the default answer. If you are mainly concerned about speeding up writes, then this is also the correct answer. If you are mainly worried about read performance then you might instead investigate pushing some critical tables/indexes onto it. regards, tom lane