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 E1A195E46E8 for ; Tue, 17 Aug 2004 12:42:24 -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 34846-01 for ; Tue, 17 Aug 2004 15:42:29 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 23EF95E37CE for ; Tue, 17 Aug 2004 12:42:20 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i7HFgSiG035136 for ; Tue, 17 Aug 2004 15:42:28 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i7HFM1QY023507 for pgsql-admin@postgresql.org; Tue, 17 Aug 2004 15:22:01 GMT From: Gaetano Mendola X-Newsgroups: comp.databases.postgresql.admin Subject: Re: What's the best way to use a Solid State HDD? Date: Tue, 17 Aug 2004 17:21:59 +0200 Organization: PYRENET Midi-pyrenees Provider Lines: 36 Message-ID: <41222297.50208@bigfoot.com> References: <4b09a0c04081705545d8e11b3@mail.gmail.com> <20040817144828.51558.qmail@web13807.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@pyrenet.fr To: Chris Gamache User-Agent: Mozilla Thunderbird 0.7.1 (Windows/20040626) X-Accept-Language: en-us, en In-Reply-To: <20040817144828.51558.qmail@web13807.mail.yahoo.com> X-Enigmail-Version: 0.84.2.0 X-Enigmail-Supports: pgp-inline, pgp-mime To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/143 X-Sequence-Number: 14538 Chris Gamache wrote: > I'm using a TiGiJet 2GB Solid State drive. How much it cost ? > 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? Depend what do you want obtain. Do you want speed up writes ? Are you annoyed by a full scan table that you can not avoid ? or what ? Regards Gaetano Mendola