> Has anyone experienced real performance gains by moving the pg_xlog
> files?

Yes.   Both for data load and on OLTP workloads, this increased write 
performance by as much as 15%.   However, you need to configure the xlog 
drive correctly, you can't just move it to a new disk.    Make sure the 
other disk is dedicated exclusively to the xlog, set it forcedirectio, and 
increase your checkpoint_segments to something like 128.


Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to