Jeff Amiel wrote:
> Recently migrated to a shiny new 8.4.4 postgres instance....data stored on attached storage array. Transaction logs
storedon 2 local mirrored drives (local to the database server itself) for best performance.
>
Have you benchmarked that this really helps? Splitting the WAL out onto
a drive pair can help a lot in some cases, but given a large attached
array the improvement tends to be minimal relative to just lumping those
writes in with the rest of the array. The easy way out of your problem
is to just not put the WAL on the local drives, and instead use them for
things like temp file storage.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.us