| From: | Karim Nassar <Karim(dot)Nassar(at)acm(dot)org> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | What's better: Raid 0 or disk for seperate pg_xlog |
| Date: | 2005-03-10 07:44:44 |
| Message-ID: | 1110440684.6368.163.camel@k2.cet.nau.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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) <some answer from someone smarter than me>
TIA,
--
Karim Nassar
Department of Computer Science
Box 15600, College of Engineering and Natural Sciences
Northern Arizona University, Flagstaff, Arizona 86011
Office: (928) 523-5868 -=- Mobile: (928) 699-9221
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Brown | 2005-03-10 14:14:36 | Re: What's better: Raid 0 or disk for seperate pg_xlog |
| Previous Message | Mischa | 2005-03-10 05:29:47 | Multi-line requests in COPY ... FROM STDIN |