Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1b6J37-00078g-2M for pgsql-performance@arkaria.postgresql.org; Fri, 27 May 2016 14:47:41 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1b6J36-0008BF-L1 for pgsql-performance@arkaria.postgresql.org; Fri, 27 May 2016 14:47: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 1b6J1Q-00060X-Kr for pgsql-performance@postgresql.org; Fri, 27 May 2016 14:45:56 +0000 Received: from mail-oi0-x22d.google.com ([2607:f8b0:4003:c06::22d]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1b6J1I-00019i-2e for pgsql-performance@postgresql.org; Fri, 27 May 2016 14:45:55 +0000 Received: by mail-oi0-x22d.google.com with SMTP id k23so177185349oih.0 for ; Fri, 27 May 2016 07:45:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pinpointresearch-com.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc; bh=KDw+hekkVuGz4ucQ6Gn5oU5qO77zyu8W+nUZPPujXv8=; b=s2cTqcyW9tLy1tB3GYWc/Eu3wIWgVsLxQoimP11cUaeg8DoxFBc1OrwgwQZyu+Rog7 CCNxQKB8ylyJitEj7Ydr8EgcknkJFS3jXisb4NZyK/AqlAUmLuu9AyjwAnr/S/I7w7/I Svx/OLdssAOt5mrXseYhLtcgkMib6vjHklIRHFGsmMmPnwfjNK3xMc33lchcA04+yTiP yzpVJfFfx3rjpnrzZ3RHToPr9JQ3zwrMoKUfzGvVvEDKE5+2OQqbA7ugQp8CQAcXsvEM TBtSeXh9PTklXX67hh76c1fVanWKOAA60dr4Zv1N64HpXcloPakpOd9goHD7vd7AofOp y71A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc; bh=KDw+hekkVuGz4ucQ6Gn5oU5qO77zyu8W+nUZPPujXv8=; b=PmYHE42nCrSsLIXwHt/phogvcgvmrkrXThOTAqAX5OefdQOKUdagWF9hOIg07yQdCP kJcSxrFesJGl3HXiNyMAditZB7t+8xgXCMsyqKqA3b5iFLKS7/yQa3DHvbG/9xB+a+sS wt2TKM1rqkZ3ldUCC8hd795T7y92m+CsHDWUu1E35q0CiUz5/L1Ap32X+EVAf8xZkGt2 8Zw+zEMfVoTveG+XDemKo7eKdL/PBPygtB9WRM7ZstfrhRBvr6ethQlQDEGnOuMSIK0B loWer3bnPAwLiR9Ux/ftp0HkcSYnis7echCVpBLxrg5ghHLC2C45YSPgxPcJ/im/V/O+ InCQ== X-Gm-Message-State: ALyK8tJ4bi5wnWlwLRx090AohOHiteFsLRnfndCI7NVTvkYvn4U0eDIXAFp4D7TllVUiUXHaS9oNZGi0BKhyN3D2 MIME-Version: 1.0 X-Received: by 10.202.214.209 with SMTP id n200mr9787239oig.39.1464360345585; Fri, 27 May 2016 07:45:45 -0700 (PDT) Received: by 10.182.39.165 with HTTP; Fri, 27 May 2016 07:45:45 -0700 (PDT) In-Reply-To: <574855F5.8070603@kth.se> References: <1464351030.15267.14.camel@kth.se> <32524.1464356784@sss.pgh.pa.us> <574855F5.8070603@kth.se> Date: Fri, 27 May 2016 07:45:45 -0700 Message-ID: Subject: Re: Performance problems with 9.2.15 From: Steve Crawford To: Johan Fredriksson Cc: pgsql-performance@postgresql.org Content-Type: multipart/alternative; boundary=001a113ad94238f7df0533d3f657 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 --001a113ad94238f7df0533d3f657 Content-Type: text/plain; charset=UTF-8 > > ...(BTW, I wonder why you are moving only to 9.2 and not something more >> recent.) >> > > Well, 9.2.15 is what comes bundled with RHEL 7, so I decided to go with > that to avoid dependency issues. But I could install a more fresh version > from scratch if that would solve my problem. > Generally my first step is to get the latest stable directly from the PostgreSQL Development Group, i.e.: yum install https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-7-x86_64/pgdg-redhat95-9.5-2.noarch.rpm Then I know I'm starting with the latest and greatest and will get critical updates without worrying about any distribution packager delays. Cheers, Steve --001a113ad94238f7df0533d3f657 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
...(BTW, I wonder why you ar= e moving only to 9.2 and not something more
recent.)

Well, 9.2.15 is what comes bundled with RHEL 7, so I decided to go with tha= t to avoid dependency issues. But I could install a more fresh version from= scratch if that would solve my problem.

Generally my first step is to get the latest stable directly from the Pos= tgreSQL Development Group, i.e.:

= Then I know I'm starting with the latest and greatest and will get crit= ical updates without worrying about any distribution packager delays.
=

Cheers,
Steve

--001a113ad94238f7df0533d3f657--