From: Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
To: Robert Kaye <rob@musicbrainz.org>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: MusicBrainz postgres performance issues
Date: Sun, 15 Mar 2015 14:27:34 +0100
Message-ID: <F3BE1A6D-8CC9-45F5-884E-6923FF8D8C06@postgresql-consulting.com> (raw)
In-Reply-To: <B008F2EE-45D7-4535-9163-56A8CDCA553C@musicbrainz.org>
References: <B008F2EE-45D7-4535-9163-56A8CDCA553C@musicbrainz.org>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Hi!
What shows your pg_stat_bgwriter for one day?
> On Mar 15, 2015, at 11:54, Robert Kaye <rob@musicbrainz.org> wrote:
>
> Hi!
>
> We at MusicBrainz have been having trouble with our Postgres install for the past few days. I’ve collected all the relevant information here:
>
> http://blog.musicbrainz.org/2015/03/15/postgres-troubles/
>
> If anyone could provide tips, suggestions or other relevant advice for what to poke at next, we would love it.
>
> Thanks!
>
> --
>
> --ruaok
>
> Robert Kaye -- rob@musicbrainz.org -- http://musicbrainz.org
>
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, rob@musicbrainz.org
Subject: Re: MusicBrainz postgres performance issues
In-Reply-To: <F3BE1A6D-8CC9-45F5-884E-6923FF8D8C06@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