From: cedric <cedric@over-blog.com>
Reply-To: cedric@over-blog.com
Organization: Over Blog
To: pgsql-performance@postgresql.org
Subject: Re: compact flash disks?
Date: Wed, 7 Mar 2007 17:12:37 +0100
User-Agent: KMail/1.9.5
Cc: "James Mansion" <james@mansionfamily.plus.com>
References: <HCEPKPMCAJLDGJIBCLGHOEBCHEAA.james@mansionfamily.plus.com>
In-Reply-To: <HCEPKPMCAJLDGJIBCLGHOEBCHEAA.james@mansionfamily.plus.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200703071712.37994.cedric@over-blog.com>

Le mardi 6 mars 2007 23:18, James Mansion a =E9crit=A0:
> I see that one can now get compact flash to SATA connectors.
I can suggest you to have a look at Gigabyte i-ram .
We use it on a website with higth traffic with lot of succes. Unfortunely, =
I=20
can not provide any benchmark...
>
> If I were to use a filesystem with noatime etc and little non-sql traffic,
> does the physical update pattern tend to have hot sectors that will tend =
to
> wear out CF?
>
> I'm wondering about a RAID5 with data on CF drives and RAID1 for teh WAL =
on
> a fast SATA or SAS drive pair.  I'm thhinking that this would tend to have
> good performance because the seek time for the data is very low, even if
> the actual write speed can be slower than state of the art.  2GB CF isn't
> so pricey any more.
>
> Just wondering.
>
> James
>
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.5.446 / Virus Database: 268.18.7/711 - Release Date: 05/03/2007
> 09:41
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly