Mark, > I suspect that making a *separate* filesystem for the pg_xlog directory > and mounting that logging + forcedirectio would be a nice way to also > get performance while keeping the advantages of logging + file > buffercache for the *rest* of the postgres components. > Cheers
Yes, we tested this. It makes a huge difference in WAL speed. -- Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
