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 D4C5D52A66 for ; Thu, 10 Mar 2005 15:27:15 +0000 (GMT) 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 57058-05 for ; Thu, 10 Mar 2005 15:26:57 +0000 (GMT) Received: from ct.radiology.uiowa.edu (ct.radiology.uiowa.edu [129.255.60.186]) by svr1.postgresql.org (Postfix) with ESMTP id 29EC056391 for ; Thu, 10 Mar 2005 15:26:55 +0000 (GMT) Received: from [192.168.1.11] (12-217-241-0.client.mchsi.com [12.217.241.0]) by ct.radiology.uiowa.edu (8.11.6/8.11.6) with ESMTP id j2AFQv309379; Thu, 10 Mar 2005 09:26:57 -0600 Message-ID: <4230673B.3020400@arbash-meinel.com> Date: Thu, 10 Mar 2005 09:26:51 -0600 From: John A Meinel User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Karim Nassar Cc: pgsql-performance@postgresql.org Subject: Re: What's better: Raid 0 or disk for seperate pg_xlog References: <1110440684.6368.163.camel@k2.cet.nau.edu> In-Reply-To: <1110440684.6368.163.camel@k2.cet.nau.edu> X-Enigmail-Version: 0.89.5.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig3B09910D8F9D6428C3A88634" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/180 X-Sequence-Number: 10885 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig3B09910D8F9D6428C3A88634 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Karim Nassar wrote: From rom http://www.powerpostgresql.com/PerfList/ > >"even in a two-disk server, you can put the transaction log onto the >operating system disk and reap some benefits." > >Context: I have a two disk server that is about to become dedicated to >postgresql (it's a sun v40z running gentoo linux). > >What's "theoretically better"? > >1) OS and pg_xlog on one disk, rest of postgresql on the other? (if I > understand the above correctly) >2) Everything striped Raid 0? >3) > >TIA, > > With 2 disks, you have 3 options, RAID0, RAID1, and 2 independent disks. RAID0 - Fastest read and write speed. Not redundant, if either disk fails you lose everything on *both* disks. RAID1 - Redundant, slow write speed, but should be fast read speed. If one disk fails, you have a backup. 2 independent - With pg_xlog on a separate disk, writing (updates) should stay reasonably fast. If one disk dies, you lose that disk, but not both. How critical is your data? How update heavy versus read heavy, etc are you? Do you have a way to restore the database if something fails? If you do nightly pg_dumps, will you survive if you lose a days worth of transactions? In general I would recommend RAID1, because that is the safe bet. If your db is the bottleneck, and your data isn't all that critical, and you are read heavy, I would probably go with RAID1, if you are write heavy I would say 2 independent disks. John =:-> --------------enig3B09910D8F9D6428C3A88634 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.6 (Cygwin) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCMGc7JdeBCYSNAAMRAkVGAKChu39z/Vx0sjhpRRh4WqgpJD2p6wCgyVN1 h6uIxwJau3cvVd6cSI6Gmzs= =Mz6i -----END PGP SIGNATURE----- --------------enig3B09910D8F9D6428C3A88634--