Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bQUnC-0000Mm-L9 for pgsql-performance@arkaria.postgresql.org; Fri, 22 Jul 2016 07:22:43 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bQUnB-0000oG-LG for pgsql-performance@arkaria.postgresql.org; Fri, 22 Jul 2016 07:22:41 +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 1bQUlV-0007LI-98 for pgsql-performance@postgresql.org; Fri, 22 Jul 2016 07:20:57 +0000 Received: from smtp-4.sys.kth.se ([2001:6b0:1:1300:250:56ff:fea6:2de3]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bQUlR-0005ZD-SV for pgsql-performance@postgresql.org; Fri, 22 Jul 2016 07:20:56 +0000 Received: from smtp-4.sys.kth.se (localhost.localdomain [127.0.0.1]) by smtp-4.sys.kth.se (Postfix) with ESMTP id 862E853 for ; Fri, 22 Jul 2016 09:20:52 +0200 (CEST) X-Virus-Scanned: by amavisd-new at kth.se Received: from smtp-4.sys.kth.se ([127.0.0.1]) by smtp-4.sys.kth.se (smtp-4.sys.kth.se [127.0.0.1]) (amavisd-new, port 10024) with LMTP id u5eABK8eIxXx for ; Fri, 22 Jul 2016 09:20:51 +0200 (CEST) X-KTH-Auth: eskil [2001:6b0:1:11f0:6e62:6dff:fe6a:ffa3] DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kth.se; s=default; t=1469172051; bh=ZbBnWcBxS+5JC45042gn+mmSJIMl9y4+Tr2Hr+M0Llg=; h=Subject:From:To:Date:In-Reply-To:References; b=LEf9vNLPLHN5i41UGa/NGieylCOwMf4IkD6snlEOopgQz+RYO5zKVe44/RM4wTSrm 4LSWFQS8NRYNylYmfmiFUIeszUVG5Q7GEicxxyL5X9n/Q5R52c98FMuXoaOM1MQeY9 tA6U3kKD5Ju/l4iF8Bn6L+Y1b142WrSwF7CBw47c= X-KTH-mail-from: eskil@kth.se X-KTH-rcpt-to: pgsql-performance@postgresql.org Received: from tiny.ite.kth.se (tiny.ite.kth.se [IPv6:2001:6b0:1:11f0:6e62:6dff:fe6a:ffa3]) by smtp-4.sys.kth.se (Postfix) with ESMTPSA id 9048E23 for ; Fri, 22 Jul 2016 09:20:51 +0200 (CEST) Message-ID: <1469172051.20190.1.camel@kth.se> Subject: Re: Performance problems with 9.2.15 From: Johan Fredriksson To: pgsql-performance@postgresql.org Date: Fri, 22 Jul 2016 09:20:51 +0200 In-Reply-To: <9be94dc4-e96f-28b2-e476-2e46b5b3deda@catalyst.net.nz> 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> <9be94dc4-e96f-28b2-e476-2e46b5b3deda@catalyst.net.nz> Organization: KTH Content-Type: text/plain; charset="UTF-8" X-Mailer: Evolution 3.12.11 (3.12.11-15.el7) Mime-Version: 1.0 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -5.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 fre 2016-07-22 klockan 19:08 +1200 skrev Mark Kirkwood: > 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! The one I found on https://www.postgresql.org/download/linux/redhat/ That page points out http://yum.postgresql.org/9.4/redhat/rhel-6-x86_64/pgdg-redhat94-9.4-1.noarch.rpm as the latest. Perhaps the download-page need to be updated? / Eskil -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance