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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings