Jeff Amiel wrote:
Recently migrated to a shiny new 8.4.4 postgres instance....data stored on attached storage array. Transaction logs stored on 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@xxxxxxxxxxxxxxx www.2ndQuadrant.us -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general