pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mark Kirkwood <markir@coretech.co.nz>
To: bsimon@loxane.com
Cc: pgsql-performance@postgresql.org
Subject: Re: Réf. : Re: [PERFORM] NAS,
Date: Tue, 20 Jul 2004 22:04:28 +1200
Message-ID: <40FCEE2C.5080502@coretech.co.nz> (raw)
In-Reply-To: <OF22014C03.D410E888-ONC1256ED7.00319D2F-C1256ED7.0034812E@beauchamp.loxane.fr>
References: <OF22014C03.D410E888-ONC1256ED7.00319D2F-C1256ED7.0034812E@beauchamp.loxane.fr>



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









Message-ID: <40FCEE2C.5080502@coretech.co.nz>
Permalink:  ../40FCEE2C.5080502@coretech.co.nz/
Also on:    postgresql.org/message-id/40FCEE2C.5080502@coretech.co.nz

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: markir@coretech.co.nz, bsimon@loxane.com
  Subject: Re: Réf. : Re: [PERFORM] NAS,
  In-Reply-To: <40FCEE2C.5080502@coretech.co.nz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox