X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 05FEED1B257 for ; Tue, 20 Jul 2004 07:02:13 -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 01608-03 for ; Tue, 20 Jul 2004 10:02:07 +0000 (GMT) Received: from linda-1.paradise.net.nz (bm-1a.paradise.net.nz [202.0.58.20]) by svr1.postgresql.org (Postfix) with ESMTP id EE3E6D1B1B3 for ; Tue, 20 Jul 2004 07:02:04 -0300 (ADT) Received: from smtp-2.paradise.net.nz (smtp-2b.paradise.net.nz [202.0.32.211]) by linda-1.paradise.net.nz (Paradise.net.nz) with ESMTP id <0I1500GO2AJI9M@linda-1.paradise.net.nz> for pgsql-performance@postgresql.org; Tue, 20 Jul 2004 22:02:07 +1200 (NZST) Received: from coretech.co.nz (218-101-12-189.paradise.net.nz [218.101.12.189]) by smtp-2.paradise.net.nz (Postfix) with ESMTP id 76C109E4CD; Tue, 20 Jul 2004 22:02:06 +1200 (NZST) Date: Tue, 20 Jul 2004 22:04:28 +1200 From: Mark Kirkwood Subject: Re: =?ISO-8859-1?Q?R=E9f=2E_=3A_Re=3A_=5BPERFORM=5D_NAS=2C?= In-reply-to: To: bsimon@loxane.com Cc: pgsql-performance@postgresql.org Message-id: <40FCEE2C.5080502@coretech.co.nz> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=us-ascii Content-transfer-encoding: 7bit X-Accept-Language: en-us, en User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.6) Gecko/20040429 References: 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: 200407/121 X-Sequence-Number: 7512 bsimon@loxane.com wrote: > > As we don't plan to have more than 5 connections (I.E process), we > think SATA drives would fit our requirements. Could this be an issue > for an after crash recovery ? > If you can disable the write ATA write cache, then you have safety. Unfortunately many cards under Linux show up as SCSI devices, and you can't access this setting. Does anyone know if the newer SATA cards let you control this? You might want to keep and eye on the upcoming native windows port in 7.5 - It will come with a fearsome array of caveats... but you have been running cygwin in production! - and I am inclined to think the native port will be more solid than this configuration. regards Mark