Re: limiting performance impact of wal archiving. - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: limiting performance impact of wal archiving.
Date
Msg-id 4AF936F3020000250002C4F7@gw.wicourts.gov
Whole thread Raw
In response to Re: limiting performance impact of wal archiving.  (Laurent Laborde <kerdezixe@gmail.com>)
Responses Re: limiting performance impact of wal archiving.  (Laurent Laborde <kerdezixe@gmail.com>)
List pgsql-performance
Laurent Laborde <kerdezixe@gmail.com> wrote:

> BTW, if you have any idea to improve IO performance, i'll happily
> read it.  We're 100% IO bound.

At the risk of stating the obvious, you want to make sure you have
high quality RAID adapters with large battery backed cache configured
to write-back.

If you haven't already done so, you might want to try
elevator=deadline.

> xfs ?

If you use xfs and have the aforementioned BBU cache, be sure to turn
write barriers off.

-Kevin

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: limiting performance impact of wal archiving.
Next
From: Laurent Laborde
Date:
Subject: Re: limiting performance impact of wal archiving.