"Olivier Andreotti" <[EMAIL PROTECTED]> writes: > Just a last question about the pg_xlog : i understand that the > directory must be moved but i have just 3 disks for the database : > disk 1 and 2 for the data, disk 3 for the indexes, where can i put the > pg_xlog ?
If you have three disks then put the xlog on one of them and everything else on the other two. Separating out the indexes is way less important than getting xlog onto its very own spindle (at least for write-intensive cases). regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings