Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bQUZd-0008Cj-34 for pgsql-performance@arkaria.postgresql.org; Fri, 22 Jul 2016 07:08:42 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bQUZc-0004qa-7K for pgsql-performance@arkaria.postgresql.org; Fri, 22 Jul 2016 07:08:40 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bQUZb-0004py-3L for pgsql-performance@postgresql.org; Fri, 22 Jul 2016 07:08:39 +0000 Received: from cat-porwal-prod-mail1.catalyst.net.nz ([202.78.240.226]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bQUZV-0005Ko-QD for pgsql-performance@postgresql.org; Fri, 22 Jul 2016 07:08:36 +0000 Received: from localhost (localhost [127.0.0.1]) by cat-porwal-prod-mail1.catalyst.net.nz (Postfix) with ESMTP id BBC3F805FF; Fri, 22 Jul 2016 19:08:27 +1200 (NZST) X-Virus-Scanned: Debian amavisd-new at cat-porwal-prod-mail1.servers.catalyst.net.nz Received: from cat-porwal-prod-mail1.catalyst.net.nz ([127.0.0.1]) by localhost (cat-porwal-prod-mail1.servers.catalyst.net.nz [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 8bXL1IKupTAI; Fri, 22 Jul 2016 19:08:27 +1200 (NZST) Received: from [192.168.1.64] (122-61-217-145.jetstream.xtra.co.nz [122.61.217.145]) (Authenticated sender: mark.kirkwood@catalyst.net.nz) by cat-porwal-prod-mail1.catalyst.net.nz (Postfix) with ESMTPSA id 13181805E8; Fri, 22 Jul 2016 19:08:27 +1200 (NZST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=catalyst.net.nz; s=catalyst; t=1469171307; bh=Wgb7/GrmFfZSsV48FjqnAS79HWga5Utq1nRgu0n1iXs=; h=Subject:To:References:Cc:From:Date:In-Reply-To; b=kPZWlypzmPwZ7IKp/JfGv+SXqw5TQ/qPhjITZblsEYKxpf/XK+pdEmixMvNHSCR6K QpW3VoAU7D6Ord1hdez17cU8z4mYAmvn+Y4zIG2EFG9V2eNdcHlTgE1MMyN/+B4A1/ L4xikbS+jWsolbVXbqTZPrwSdiVJGx4j1Itj5nlE= Subject: Re: Performance problems with 9.2.15 To: Johan Fredriksson References: <1464351030.15267.14.camel@kth.se> <32524.1464356784@sss.pgh.pa.us> <1464593729.16712.2.camel@kth.se> <1464616618.19212.3.camel@kth.se> <1469112481.11501.12.camel@kth.se> <1469149167892.29906@kth.se> <1469149648829.4862@kth.se> Cc: postgres performance list From: Mark Kirkwood Message-ID: <9be94dc4-e96f-28b2-e476-2e46b5b3deda@catalyst.net.nz> Date: Fri, 22 Jul 2016 19:08:26 +1200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.2.0 MIME-Version: 1.0 In-Reply-To: <1469149648829.4862@kth.se> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -3.3 (---) 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 22/07/16 13:07, Johan Fredriksson wrote: > And by the way, I have also tried to upgrade to Postgresql 9.4.8 (the latest version in postgresl.org's own repository) without improvment. > Not sure what repo you are using, but 9.5.3 and 9.6 Beta are the *actual* latest versions. Now I'm not sure they will actually help your particular query, but are probably worth a try out! regards Mark -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance