jose fuenmayor <jafn82@xxxxxxxxx> writes: > How can I install pg_xlog (WAL) in another partition, i mean separate the > data directory from WAL, i have a single scsi disk with four partitions > /, /boot, /data(data for postgresql), /WAL(pg_xlog), i ve heard that by > doing this occurs a boost in postgreSQL performance, thanks in advance > anyone that helps me. If there's only one physical disk spindle, there is no performance value in spreading PG across multiple partitions on that disk --- in fact that will likely be a net loss, because it'll force larger seek distances between the different files the database has to access. The common recommendation is to put WAL on a separate *physical disk*. If you don't have multiple disks there's no advantage to be gained. (I have seen people put WAL on a separate logical partition anyway, because it insulates the WAL from possible out-of-disk-space conditions in the other partitions, which is a good thing because out-of-space is a PANIC condition for WAL but not for the main DB. But if you're doing it because you think you'll gain performance you are misguided.) regards, tom lane
