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 022965E46C3 for ; Tue, 17 Aug 2004 11:48:25 -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 05107-09 for ; Tue, 17 Aug 2004 14:48:26 +0000 (GMT) Received: from web13807.mail.yahoo.com (web13807.mail.yahoo.com [216.136.175.17]) by svr1.postgresql.org (Postfix) with SMTP id E64475E46E6 for ; Tue, 17 Aug 2004 11:48:22 -0300 (ADT) Message-ID: <20040817144828.51558.qmail@web13807.mail.yahoo.com> Received: from [216.173.173.66] by web13807.mail.yahoo.com via HTTP; Tue, 17 Aug 2004 07:48:28 PDT Date: Tue, 17 Aug 2004 07:48:28 -0700 (PDT) From: Chris Gamache Reply-To: cgg007@yahoo.com Subject: What's the best way to use a Solid State HDD? To: pgsql-admin@postgresql.org In-Reply-To: <4b09a0c04081705545d8e11b3@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.9 tagged_above=0.0 required=5.0 tests=FROM_ENDS_IN_NUMS X-Spam-Level: X-Archive-Number: 200408/142 X-Sequence-Number: 14537 I'm using a TiGiJet 2GB Solid State drive. My thought was to place the WAL on it to speed up writes. I don't know of any tools that exist to determine the effectiveness of this except for anecdotal analysis (This type of query took 3 minutes yesterday, and 1 minute today) ... Sar gives me machine-wide stats, but we do more than PostgreSQL here. I can enable stats, but will that tell me what I'm looking for? Vmstat reports no swapping of pages of ram to disk, so I don't think it would make sense to make it a Linux Swap drive. I suppose I could move some actual tables and indexes to the device. Tablespaces might make this easy. I'm still using 7.4.3. If I had to pick between tables and indexes, which would make more sense to put on the solid-state device? What would you do if you had a solid state hdd to use and you wanted to speed up PostgreSQL? __________________________________ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail