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 2EEF0D1B9A6 for ; Thu, 4 Sep 2003 13:49:21 +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 39231-01 for ; Thu, 4 Sep 2003 10:49:14 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id B71DCD1B98D for ; Thu, 4 Sep 2003 10:49:09 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h84DmmjX021374; Thu, 4 Sep 2003 09:48:48 -0400 (EDT) To: Sean Chittenden Cc: Shridhar Daithankar , PostgreSQL Performance Mailing List Subject: Re: PostgreSQL Reliability when fsync = false on Linux-XFS In-reply-to: <20030904072735.GB75041@perrin.nxad.com> References: <20030904030404.GA32319@leathercollection.ph> <3F57316B.21521.9DD1CF4@localhost> <20030904072735.GB75041@perrin.nxad.com> Comments: In-reply-to Sean Chittenden message dated "Thu, 04 Sep 2003 00:27:35 -0700" Date: Thu, 04 Sep 2003 09:48:48 -0400 Message-ID: <21373.1062683328@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/59 X-Sequence-Number: 3425 Sean Chittenden writes: >> 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... Also, doesn't flash memory have a very limited lifetime in write cycles? Using it as WAL, you'd wear it out PDQ. regards, tom lane