X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E98D5475F6A for ; Thu, 27 Feb 2003 12:27:25 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 78476-06 for ; Thu, 27 Feb 2003 12:27:13 -0500 (EST) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by postgresql.org (Postfix) with ESMTP id 38787475F55 for ; Thu, 27 Feb 2003 11:58:42 -0500 (EST) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 2872289; Thu, 27 Feb 2003 08:58:30 -0800 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: Murthy Kambhampaty Subject: Re: Data write speed Date: Thu, 27 Feb 2003 08:57:32 -0800 User-Agent: KMail/1.4.3 References: <2D92FEBFD3BE1346A6C397223A8DD3FC092171@THOR.goeci.com> In-Reply-To: <2D92FEBFD3BE1346A6C397223A8DD3FC092171@THOR.goeci.com> Cc: pgsql-performance@postgresql.org MIME-Version: 1.0 Message-Id: <200302270857.32247.josh@agliodbs.com> Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/234 X-Sequence-Number: 1290 Murthy, > You could get mondo (http://www.microwerks.net/~hugo/), then backup your > system to CDs and restore it with the new filesystem layout. You might wa= nt > to do these backups as a matter of course? Thanks for the suggestion. The problem isn't backup media ... we have a D= LT=20 drive ... the problem is time. This particular application is already abo= ut=20 4 weeks behind schedule because of various hardware problems. At some poin= t,=20 Kevin Brown and I will take a weekend to swap the postgres files to a spare= =20 disk, and re-format the data array as pass-through Linux RAID. And this is the last time I leave it up to the company sysadmin to buy=20 hardware for a database server, even with explicit instructions ... "Yes, I= =20 saw which one you wanted, but the 2200S was on sale!" --=20 Josh Berkus Aglio Database Solutions San Francisco