Re: performance tuning - splitting data and logs
Posted: Thu May 07, 2009 10:13 am
You're welcome and I'm glad we could get things sorted out for you
kraada wrote:That should work as well.
WhiteRider wrote:Having your database on the fastest drive will give you the best performance. Writing logs to a separate disk will help because all the disk access on the DB drive will be concentrated on database access.
Traclugator wrote:...it seems to me that
#log_directory = 'pg_log'
is NOT for WRITE AHEAD LOG but only for error reporting