Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YX8a1-0003fS-W8 for pgsql-performance@arkaria.postgresql.org; Sun, 15 Mar 2015 13:27:46 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YX8a1-0005FC-Dd for pgsql-performance@arkaria.postgresql.org; Sun, 15 Mar 2015 13:27:45 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YX8Zz-0005C5-EF for pgsql-performance@postgresql.org; Sun, 15 Mar 2015 13:27:43 +0000 Received: from mail-wi0-f169.google.com ([209.85.212.169]) by makus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YX8Zw-00060h-3S for pgsql-performance@postgresql.org; Sun, 15 Mar 2015 13:27:41 +0000 Received: by wifj2 with SMTP id j2so22068913wif.1 for ; Sun, 15 Mar 2015 06:27:38 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:content-type:mime-version:subject:from :in-reply-to:date:cc:content-transfer-encoding:message-id:references :to; bh=Kv4aNMQIR4PYYsnVwpWxOz2MsjRyN0bcSxEbDEA7c58=; b=NUu8FCsHpTQlziy/Tyx7jAadZND9LNJoxNfum0S8QRM0Phkj6tsJKs84qIUzejTq31 H+gvKfdv2H986V/kNwidYCVJmt1LT0jtX1To11kLyFCJlvAeuWfsVdGf30xbK9TYpEdb wAkWe7ODhOxjuTU39Lv4A/zgSu7hl7fJkWDJWM9sBLYAHdXDMAbP6cf3Q+G7kT7HBD6W u0xsyDryAArXPv/Q+3LC9i0m8zhbTd0hQtpK+uTQsjt3tMK/0uTDiKSAKzY7Il5hjR6D mUspjHVHWCTYxyvB1VmaE/4JhWQY1sNbxKl4ZYPdizdr/tozdUsfo044Og2Z+E2RUevQ OngQ== X-Gm-Message-State: ALoCoQnEmmj7u94xVcfTkC9wIcz+wL5cPcfup9HpSu7YxDqq2/tfV6V5cyzh9FAfx1K+QEdwdHxh X-Received: by 10.194.87.100 with SMTP id w4mr110364491wjz.65.1426426058109; Sun, 15 Mar 2015 06:27:38 -0700 (PDT) Received: from [10.56.92.182] (tmo-101-187.customers.d1-online.com. [80.187.101.187]) by mx.google.com with ESMTPSA id gd6sm10990520wib.17.2015.03.15.06.27.36 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Sun, 15 Mar 2015 06:27:37 -0700 (PDT) Content-Type: multipart/alternative; boundary=Apple-Mail-CD52DEAA-0AA6-4530-A392-B7D0B0C2C62C Mime-Version: 1.0 (1.0) Subject: Re: MusicBrainz postgres performance issues From: Ilya Kosmodemiansky X-Mailer: iPhone Mail (12B440) In-Reply-To: Date: Sun, 15 Mar 2015 14:27:34 +0100 Cc: "pgsql-performance@postgresql.org" Content-Transfer-Encoding: 7bit Message-Id: References: To: Robert Kaye X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org --Apple-Mail-CD52DEAA-0AA6-4530-A392-B7D0B0C2C62C Content-Type: text/plain; charset=windows-1251 Content-Transfer-Encoding: quoted-printable Hi! What shows your pg_stat_bgwriter for one day?=20 > On Mar 15, 2015, at 11:54, Robert Kaye wrote: >=20 > Hi! >=20 > We at MusicBrainz have been having trouble with our Postgres install for t= he past few days. I=92ve collected all the relevant information here: >=20 > http://blog.musicbrainz.org/2015/03/15/postgres-troubles/ >=20 > If anyone could provide tips, suggestions or other relevant advice for wha= t to poke at next, we would love it. >=20 > Thanks! >=20 > -- >=20 > --ruaok =20 >=20 > Robert Kaye -- rob@musicbrainz.org -- http://musicbrainz.or= g >=20 --Apple-Mail-CD52DEAA-0AA6-4530-A392-B7D0B0C2C62C Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Hi!

What show= s your pg_stat_bgwriter for one day? 


On Mar 15, 2= 015, at 11:54, Robert Kaye <rob@mu= sicbrainz.org> wrote:

Hi!
We at MusicBrainz have been= having trouble with our Postgres install for the past few days. I=E2=80=99v= e collected all the relevant information here:

  http://blog.musicbrainz.org/20= 15/03/15/postgres-troubles/

If anyone could provide tips, suggestions or other relevant ad= vice for what to poke at next, we would love it.

Thanks!

<= /div>
--

--ruaok    &n= bsp;   

Robert Kaye   =   --     rob@musicbrainz.org     --  &= nbsp; http://musicbrainz.= org

= --Apple-Mail-CD52DEAA-0AA6-4530-A392-B7D0B0C2C62C--