X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 71CA0D1B8BE for ; Thu, 4 Sep 2003 07:27:45 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 11194-01 for ; Thu, 4 Sep 2003 04:27:36 -0300 (ADT) Received: from perrin.nxad.com (internal.nxad.com [69.1.70.251]) by svr1.postgresql.org (Postfix) with ESMTP id 731ECD1B8E9 for ; Thu, 4 Sep 2003 04:27:34 -0300 (ADT) Received: by perrin.nxad.com (Postfix, from userid 1001) id 395A021058; Thu, 4 Sep 2003 00:27:35 -0700 (PDT) Date: Thu, 4 Sep 2003 00:27:35 -0700 From: Sean Chittenden To: Shridhar Daithankar Cc: PostgreSQL Performance Mailing List Subject: Re: PostgreSQL Reliability when fsync = false on Linux-XFS Message-ID: <20030904072735.GB75041@perrin.nxad.com> References: <20030904030404.GA32319@leathercollection.ph> <3F57316B.21521.9DD1CF4@localhost> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3F57316B.21521.9DD1CF4@localhost> X-PGP-Key: finger seanc@FreeBSD.org X-PGP-Fingerprint: 3849 3760 1AFE 7B17 11A0 83A6 DD99 E31F BC84 B341 X-Web-Homepage: http://sean.chittenden.org/ User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/53 X-Sequence-Number: 3419 > Just wonderin. What if you symlink WAL to a directory which is on > mounted USB RAM drive? USB 2.0 you mean? It supposedly runs at 1394 speeds, but USB 1.0/1.1 runs at 1MB/s under ideal circumstances... that's slower than even old IDE drives. > Will that increase any throughput? Probably not... > I am sure a 256/512MB flash drive will cost lot less than a SCSI > disk. May be even a GB on flash drive would do.. That's true... but on a per $$/MB, you're better off investing in RAM and increasing your effective_cache_size. If dd to a flash card is faster than to an IDE drive, please let me know. :) -sc -- Sean Chittenden UNIX(TM), a BSD like Operating System