pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
To: Josh Krupka <jkrupka@gmail.com>
Cc: Robert Kaye <rob@musicbrainz.org>
Cc: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: MusicBrainz postgres performance issues
Date: Sun, 15 Mar 2015 14:30:19 +0100
Message-ID: <4CA26C8B-B233-4B57-A236-32B0CD747C08@postgresql-consulting.com> (raw)
In-Reply-To: <CAB6McgW3f+tPzjj0KQwuOr6L6f82WZerycjPGeuLrfLBDzceyg@mail.gmail.com>
References: <B008F2EE-45D7-4535-9163-56A8CDCA553C@musicbrainz.org>
	<CAB6McgXxZdD6yuYRLg4tgDdhqzXKLs63aV+S_nOfZ9arSXUAhA@mail.gmail.com>
	<9E71CCBE-4CDF-482E-878D-6C16027B6283@musicbrainz.org>
	<CAB6McgW3f+tPzjj0KQwuOr6L6f82WZerycjPGeuLrfLBDzceyg@mail.gmail.com>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>




> On Mar 15, 2015, at 13:45, Josh Krupka <jkrupka@gmail.com> wrote:
> Hmm that's definitely odd that it's swapping since it has plenty of free memory at the moment.  Is it still under heavy load right now?  Has the output of free consistently looked like that during your trouble times?

And it seems better to disable swapiness 


> 


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



view thread (41+ messages)  latest in thread

Message-ID: <4CA26C8B-B233-4B57-A236-32B0CD747C08@postgresql-consulting.com>
Permalink:  ../4CA26C8B-B233-4B57-A236-32B0CD747C08@postgresql-consulting.com/
Also on:    postgresql.org/message-id/4CA26C8B-B233-4B57-A236-32B0CD747C08@postgresql-consulting.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: ilya.kosmodemiansky@postgresql-consulting.com, jkrupka@gmail.com, rob@musicbrainz.org
  Subject: Re: MusicBrainz postgres performance issues
  In-Reply-To: <4CA26C8B-B233-4B57-A236-32B0CD747C08@postgresql-consulting.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox