Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YXBhB-0000YR-SJ for pgsql-performance@arkaria.postgresql.org; Sun, 15 Mar 2015 16:47:21 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YXBhB-00072D-BK for pgsql-performance@arkaria.postgresql.org; Sun, 15 Mar 2015 16:47:21 +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 1YXBhA-00071z-F6 for pgsql-performance@postgresql.org; Sun, 15 Mar 2015 16:47:20 +0000 Received: from lists.commandprompt.com ([69.168.55.30]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YXBh6-0001Kc-Is for pgsql-performance@postgresql.org; Sun, 15 Mar 2015 16:47:18 +0000 Received: from [192.168.1.3] (spinlock.commandprompt.com [69.168.55.30]) by lists.commandprompt.com (Postfix) with ESMTPA id E81F92E2; Sun, 15 Mar 2015 09:47:14 -0700 (PDT) Received: from [192.168.1.3] ([67.168.169.165] helo=[192.168.1.3]) by assp.commandprompt.com with ESMTPS(AES128-SHA) (2.1.1); 15 Mar 2015 09:47:14 -0700 Message-ID: <5505B798.3000405@commandprompt.com> Date: Sun, 15 Mar 2015 09:47:20 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.5.0 MIME-Version: 1.0 To: Robert Kaye , Andreas Kretschmer CC: pgsql-performance@postgresql.org Subject: Re: MusicBrainz postgres performance issues References: <20150315114123.GA7529@tux> <0D72E149-EE2F-4E5F-9FAE-6FA902960A29@musicbrainz.org> In-Reply-To: <0D72E149-EE2F-4E5F-9FAE-6FA902960A29@musicbrainz.org> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit X-Assp-Version: 2.1.1(11364) on assp.commandprompt.com X-Assp-Client-SSL: yes X-Assp-ID: assp.commandprompt.com m1-38034-07712 X-Assp-Envelope-From: jd@commandprompt.com X-Assp-Intended-For: pgsql-performance@postgresql.org X-Assp-Original-Subject: Re: [PERFORM] MusicBrainz postgres performance issues X-Pg-Spam-Score: -1.9 (-) 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 On 03/15/2015 05:08 AM, Robert Kaye wrote: > > >> On Mar 15, 2015, at 12:41 PM, Andreas Kretschmer wrote: >> >> just a wild guess: raid-controller BBU faulty > > We don’t have a BBU in this server, but at least we have redundant power supplies. > > In any case, how would a fault batter possibly cause this? The controller would turn off the cache. JD > > -- > > --ruaok > > Robert Kaye -- rob@musicbrainz.org -- http://musicbrainz.org > > > -- Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564 PostgreSQL Support, Training, Professional Services and Development High Availability, Oracle Conversion, @cmdpromptinc Now I get it: your service is designed for a customer base that grew up with Facebook, watches Japanese seizure robot anime, and has the attention span of a gnat. I'm not that user., "Tyler Riddle" -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance