Re: MusicBrainz postgres performance issues - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: MusicBrainz postgres performance issues
Date
Msg-id CAOR=d=2TRBS_9aMwMMaMOuDiFuTwCC+in+t3_2dWbr9EPzUXMQ@mail.gmail.com
Whole thread Raw
In response to Re: MusicBrainz postgres performance issues  (Robert Kaye <rob@musicbrainz.org>)
List pgsql-performance
On Mon, Mar 16, 2015 at 6:59 AM, Robert Kaye <rob@musicbrainz.org> wrote:
>
> 4. Linux 3.2 apparently has some less than desirable swap behaviours. Once
> we started swapping, everything went nuts.

On older machines I used to just turn off swap altogether. Esp if I
wasn't running out of memory but swap was engaging anyway. swappiness
= 0 didn't help, nothing did, I just kept seeing kswapd working it's
butt off doing nothing but hitting the swap partition.

So glad to be off those old kernels.


pgsql-performance by date:

Previous
From: Jim Nasby
Date:
Subject: Re: MusicBrainz postgres performance issues
Next
From: Tomas Vondra
Date:
Subject: Re: Performance issues