| From: | Mario Weilguni <mweilguni(at)sime(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Cc: | Karim Nassar <Karim(dot)Nassar(at)acm(dot)org> |
| Subject: | Re: What's better: Raid 0 or disk for seperate pg_xlog |
| Date: | 2005-03-10 16:41:28 |
| Message-ID: | 200503101741.28407.mweilguni@sime.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Am Donnerstag, 10. März 2005 08:44 schrieb Karim Nassar:
> 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>
Because of hard disk seeking times, a separate disk for WAL will be a lot
better.
regards
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karim Nassar | 2005-03-10 19:50:31 | Re: What's better: Raid 0 or disk for seperate pg_xlog |
| Previous Message | John A Meinel | 2005-03-10 15:26:51 | Re: What's better: Raid 0 or disk for seperate pg_xlog |