Re: MusicBrainz postgres performance issues

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Robert Kaye <rob(at)musicbrainz(dot)org>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: MusicBrainz postgres performance issues
Date: 2015-03-16 20:29:34
Message-ID: CAOR=d=2TRBS_9aMwMMaMOuDiFuTwCC+in+t3_2dWbr9EPzUXMQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Mar 16, 2015 at 6:59 AM, Robert Kaye <rob(at)musicbrainz(dot)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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tomas Vondra 2015-03-16 20:59:16 Re: Performance issues
Previous Message Jim Nasby 2015-03-16 20:01:04 Re: MusicBrainz postgres performance issues