Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YX7gB-0002Bk-64 for pgsql-performance@arkaria.postgresql.org; Sun, 15 Mar 2015 12:30:03 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YX7gA-0005iy-HG for pgsql-performance@arkaria.postgresql.org; Sun, 15 Mar 2015 12:30:02 +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 1YX7g9-0005ip-7h for pgsql-performance@postgresql.org; Sun, 15 Mar 2015 12:30:01 +0000 Received: from mail-pa0-x235.google.com ([2607:f8b0:400e:c03::235]) by makus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YX7g1-0004uv-7z for pgsql-performance@postgresql.org; Sun, 15 Mar 2015 12:29:59 +0000 Received: by pagr17 with SMTP id r17so36140421pag.0 for ; Sun, 15 Mar 2015 05:29:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=from:message-id:date:user-agent:mime-version:to:subject:references :in-reply-to:content-type:content-transfer-encoding; bh=PyLw4WraNTbq+rlxIGNcnBxmxzCRaYnWu4wBpYEGLnw=; b=K1IlTvpphlCZ+LtsUcVOvBnJsCthX+U2a7RhMjIz8TrKod13fQLG9pPSQ9owl3Q9UO 1cxKnIITLQJ7mzrZGK31FzzqjQIltQztm3qPAbdKT85kF6ndl6bOxAQTHr7Y8rgSQsAG Aihnn2KENYx1nsiSbgAUkmXRpiSbi7eGq0hxq8PzA8Kvtx+xiHRdkDFD/9FpUz+eNynV UVibpwEVsrKmfFaBY+pNcv8f0pAvhVJ4f8cx1flx59pvgNvDaszyRNzfwILsldXmhvmC xbifH/N6F/QkkcfGY0oWwKBLrTOj1su6mxGYu4x+m3e6TYvXaHkH6YXFMFDRiEvvRm1+ lOiw== X-Received: by 10.66.216.40 with SMTP id on8mr77338502pac.27.1426422591825; Sun, 15 Mar 2015 05:29:51 -0700 (PDT) Received: from [192.168.11.8] ([180.165.10.7]) by mx.google.com with ESMTPSA id t5sm12272869pde.51.2015.03.15.05.29.50 for (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sun, 15 Mar 2015 05:29:51 -0700 (PDT) From: Rural Hunter X-Google-Original-From: Rural Hunter Message-ID: <55057B27.3080606@gmail.com> Date: Sun, 15 Mar 2015 20:29:27 +0800 User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:31.0) Gecko/20100101 Thunderbird/31.5.0 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: MusicBrainz postgres performance issues References: In-Reply-To: Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit X-Pg-Spam-Score: -2.0 (--) 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
pls check this if it helps: http://ubuntuforums.org/showthread.php?t=2258734

在 2015/3/15 18:54, Robert Kaye 写道:
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:


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