Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aBZEp-0007vd-6s for pgsql-performance@arkaria.postgresql.org; Wed, 23 Dec 2015 02:33:15 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aBZEo-0001q2-P6 for pgsql-performance@arkaria.postgresql.org; Wed, 23 Dec 2015 02:33:14 +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) (envelope-from ) id 1aBZEn-0001pA-6n; Wed, 23 Dec 2015 02:33:13 +0000 Received: from mail-bn1on0087.outbound.protection.outlook.com ([157.56.110.87] helo=na01-bn1-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aBZEh-0004D0-W2; Wed, 23 Dec 2015 02:33:12 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=BlueTreble.onmicrosoft.com; s=selector1-bluetreble-com; h=From:To:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=HeUHL8tYHJUO0isQwZtK+Z6IlZfEofCzJgz9Bc6JZmg=; b=H3unNRYf5Mn3bkcgNpEriWhNTAxy8yIOkpjSaZVD8A5NC3y5h6j6cvK0djk9RU3OfQpDocDDW/KwF++aEJ4GDgyglLdqRsz/bteCJpZ1gfSSKhL9ca94QDcuefEEjMm5VVCvkGvjE8OljV03ffdabJdBx+R0j6oD1iEbijgKXvg= Authentication-Results: spf=none (sender IP is ) smtp.mailfrom=Jim.Nasby@bluetreble.com; Received: from decina.local (70.113.16.71) by SN1PR11MB0687.namprd11.prod.outlook.com (10.163.207.145) with Microsoft SMTP Server (TLS) id 15.1.361.13; Wed, 23 Dec 2015 02:33:01 +0000 Subject: Re: Connections "Startup" To: Pavel Stehule , Artem Tomyuk References: CC: "pgsql-performance@postgresql.org" , pgsql-admin From: Jim Nasby Message-ID: <567A07D9.7060401@BlueTreble.com> Date: Tue, 22 Dec 2015 20:32:57 -0600 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:38.0) Gecko/20100101 Thunderbird/38.4.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [70.113.16.71] X-ClientProxiedBy: BY2PR04CA0001.namprd04.prod.outlook.com (10.255.247.11) To SN1PR11MB0687.namprd11.prod.outlook.com (25.163.207.145) X-Microsoft-Exchange-Diagnostics: 1; SN1PR11MB0687; 2:dRC27hNebTIy/pApA6bSSlO0VpSohja9xfdsOG//PHBA54fbaRemyFa02fcWuHmiO3s7Hn2YtOzqtMCpW1W+2sp53I6ympf7s2Q+kAi4IlEFFysUE1X9EyXLQpe2JYfDjsnc0ecj1mNtZAPN2GGccA==; 3:44qzsPoXb1ftmsX8WpxQ0Qdb4BWnWkh6yBlT50j4eWTnHtOcjN++KNT6DC9F9v5UgiRlRBqZAZk63VODuSkH99b06I5SsoI2TruaqfwF8l9fTYbUBzkC9Db+EO1K0h5G; 25:kG75MtlX9Elstbxn2RAEM7r8Bg4r/423IZp7EvAQzidMBTv1+nZ9gPdsb3gXKmJeCEkJJ35dy3kmypm88AEP+MNv7WtMsdXUPr7ZNxpquG+G+T11msq+YhZneBhNji6pcFFaUbs8B6YePoB+X101UbDJSKddk0ctwDrK/Ui632WW5Rng5g7vZNJp9BrobmIwQGLNpkqvhednEm7YM0VHLnyQ9do/+EOlz9S8At7BpcYn5MkYKQtP7/DNw0zgFxHKTvKxKX+Ka5ycMtADpcy73Q==; 20:DcNCSl4Cv0DtMErjDdpxgeE4TNQZyUU7GbH1uHp7MkGTQHyil5Q1XD3uXiRpXFiJXI7nN9oXsyOR3RaZtrXYWlXYuuZDLUTnFbz1VKjqyeruP6oZRAh1rjiYlBnbLCD2dZxEpzv/TX9ajOa9IKOXNaOYIzXtvSWDwwiXw+44JAc= X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:SN1PR11MB0687; X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:; X-Exchange-Antispam-Report-CFA-Test: BCL:0; PCL:0; RULEID:(601004)(2401047)(520078)(5005006)(8121501046)(10201501046)(3002001); SRVR:SN1PR11MB0687; BCL:0; PCL:0; RULEID:; SRVR:SN1PR11MB0687; X-Microsoft-Exchange-Diagnostics: 1; SN1PR11MB0687; 4:x9kr0R1BvS6wGxGKmQFTKuQ+S4d+0WY4mJ1AlmQu0VC5qangB+R9SlYQQSvF6ZIp4zqG7jB1a3r3/+1uTIusXP3CT5ZxTGyAZIELej0F5wfS7ljsChcyvE8Q3/u09tLQMf9Ua97Rx+jxs+b/lSy3xKaJVynR7HoKXpt6ZW6DCnS3O69+2aN75Opo+tZaExAAkCkXnMWVHuTWYgSJrcAFo//6HoJS4ZXUfeH3XKLfjIM3JjeUW7kII2CgX3EOrru8vQkMfMnJ3xxSzWfpzlaV+JkzjzJxskz0P9dBFc3BYNF0+HvXp9VutoRUyq563zRLLZrkEVJasIl/KC2YkbWX3Haf8wG2eBWfD5f1tuTfBz4w7m/LUmIEd9+ffDP6BobJ X-Forefront-PRVS: 0799B1B2D7 X-Forefront-Antispam-Report: SFV:NSPM; SFS:(10009020)(6009001)(24454002)(377454003)(199003)(189002)(479174004)(97736004)(101416001)(1096002)(65956001)(230700001)(2950100001)(33656002)(92566002)(6116002)(3846002)(80316001)(86362001)(5008740100001)(83506001)(36756003)(40100003)(122386002)(50466002)(586003)(189998001)(23676002)(65806001)(64126003)(65816999)(81156007)(5004730100002)(15975445007)(59896002)(5001770100001)(66066001)(76176999)(19580395003)(42186005)(87266999)(105586002)(50986999)(54356999)(47776003)(77096005)(106356001)(4001350100001)(5001960100002)(87976001)(85282002)(336755003)(18886065003); DIR:OUT; SFP:1101; SCL:1; SRVR:SN1PR11MB0687; H:decina.local; FPR:; SPF:None; PTR:InfoNoRecords; A:1; MX:1; LANG:en; Received-SPF: None (protection.outlook.com: bluetreble.com does not designate permitted sender hosts) X-Microsoft-Exchange-Diagnostics: =?utf-8?B?MTtTTjFQUjExTUIwNjg3OzIzOlEvQUhnQlRxU2haOHdIc3pvZG42M3U3aytN?= =?utf-8?B?N0ExWHFRNVFWcHUwVzZGMFRwUlVQUkcwNnc0MzNQeVRoeXlhQlA3UjlUTlpQ?= =?utf-8?B?Mm11b2JQMjAvd0t3S1VHdFd2OFJiMm9WWXFZY0R3NVh2eFIyVHEyeGdvZHZz?= =?utf-8?B?bzdYZ2lCamwwR2RCRW5qbnpMRFA4SDVneWFjMitXdkdnRmtRN1EzdHRUNnp6?= =?utf-8?B?ZzZUVEozUnVzVFpiemMxN3NpbjdVdWtFK0ZoYTNpYVI5b1NWMXBGUFZ4Rm5h?= =?utf-8?B?akE4b0ZhV0RNZEtibDliV1VudTRGQUZFRzdtdmFDc0xWYXE3eVA5dkVtdXE2?= =?utf-8?B?R3h1QUxNME1aanBJbWZSc0tLZlB1aEpPL3lPNzJocDlGVmhyMWx1eXpjMWZk?= =?utf-8?B?SUpxaTE2ZUJOMmlKcGJyTlg3cHd3WUhpRFJhYXRjOE0zeDJ4cDJCeGdSVUw0?= =?utf-8?B?c0hzWWVNWmNtN005NFo4aUpwUE1VRU5zM1Y0VU1FZVNxd1ZyVmNvaXRTMlFn?= =?utf-8?B?d3d2SjN5dVVlemRNSHUvZnJlOWFvQTRPdnZSN1dnM0x4NEQrYm0wbEJoZzJ0?= =?utf-8?B?NG02UWs3bUk4Y2NOZkJwZTZSNXVoY1RVQkNFQ201Tko4dUM0RnlydmFoekwv?= =?utf-8?B?TmdQazkxN0ZOU01OOFZvaWx5bG9JSVk1b25KSEhEcXVvbnlHdTBPZURoMDNY?= =?utf-8?B?WWJ0TlExQTZhUnE0aFFYQnNSNFJQWW1sQ3lPRG5FY1JDRXlqY3libkdWRWtN?= =?utf-8?B?OW1iMVYzNVBTaXY5b1Jxa1RTZnRMY2VCT0FCRzVuaXgvOHNYdHFoTEErWFRN?= =?utf-8?B?blZUMmErYWMvMTRnR1Y3OFUxWmdHN0RvZXN1a3plSlpscjBmeGhkckZmU3A1?= =?utf-8?B?RGlrdkdNYXgxNHQvVHpYM3JHQ2RQVDdHeTQ5NXZ2ZThESEJSa0dMM0NJYXlC?= =?utf-8?B?R0ViUGU2QVJLUDVKL3VrcWQ2MDQvTHVjOHF3cDlrek9yQUkrMGZVem5NQkRN?= =?utf-8?B?MWpycyttYmRnWENoSW1tUnhKNlRoT0thaWFPVDluajY5bmpXNURUVHZZQWhP?= =?utf-8?B?VHh1b1RxVmJhRXNDMjMyZmo5ZnZNamF0VGphMXp0d1FVK1hFQzhuaVJXOFNY?= =?utf-8?B?TGc2amJueUdVaXZ1bDRUUVAzWEJMQklWSXRCLytmMXVaMmxGejBPOFd3Y2Rs?= =?utf-8?B?TGRrbTNyU3BSQzJHRmNmRkd4MS80aVhBb2NTdHJVa09xTGJwSW0rT21UMWRn?= =?utf-8?B?NFYxeDRJeWNFVDdBYnp2b3ZuaExmVFQvUmF1c3VXekluSUpLd3lXWXpSeGxQ?= =?utf-8?B?ajR1ZE1ydmVtaGVDYmZZd29BQ3NPYjJ5UHF3cG5FRTN4cUdVTHVNN2I2L3hk?= =?utf-8?B?bUd4a2JjSlVjVCs3ZFZ5R3h4bnlWbFVEY2ZMU2VCVitRbUNVZFM3bWpKeldN?= =?utf-8?B?MDJneWw0NUMwUUttRDFDS2ZLWHh2Tko0L2lxTjN6NFFJVFFvL1d6YVZKYjI4?= =?utf-8?B?YjBoWmpiWlhwcG05VThablIxK2QxT0pRQlpXeFRIczZ1UHRha1ltNExpVkNv?= =?utf-8?B?NVlhbGg1eGpLc3k5andRcXlHUUhZM2F4V2dNcmZYdXd0b004YVQ2UFc5cFNq?= =?utf-8?B?aUExZGt5REJWZUNkQ1NEQjJuNlJVMUh3UFZnRlh3SE1ON01DK0NSZ2VCdURJ?= =?utf-8?B?Q1ZYUGlOa1dZU20yVGNaRVVWd1BBTUw0ejNvdlFXbmdwTlYwdk9Cd2duZU1M?= =?utf-8?B?RjhscGl5NytMdy9tbVN4ZW84Nkh1ckdvY1pUVTNGa09qa0I3U2JkMWE5Rm12?= =?utf-8?B?bU9aTDVKZytpODV3QTI3UUtxTklZUXJyYnNZeEZGdGZIdmc9PQ==?= X-Microsoft-Exchange-Diagnostics: 1; SN1PR11MB0687; 5:fNZzADnCKqcy01HKCtWujaYSehgfLtO2ZEjd7kSSch8juhCpU553uoy0OWdgxhrR1CAhhaoRN8X+GyNiEKpiDhowrg+Lz2uxBbbctBv5Deiww9IUqobb74MqzB0y3HA6YT/P4H90GWJ2iJaLVkhfIw==; 24:zUaYxfAcIFdSPouy7Vu26MOxG4wReD0pWTFWlaQb9n+YfFUspR7VXxwNnPHCQIvDaOf8Vxx32MozvWOO/n+xlfUzUc8jtWU/ZbWKTgpArOI= SpamDiagnosticOutput: 1:23 SpamDiagnosticMetadata: NSPM X-OriginatorOrg: bluetreble.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 23 Dec 2015 02:33:01.9380 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-Transport-CrossTenantHeadersStamped: SN1PR11MB0687 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 12/22/15 2:09 AM, Pavel Stehule wrote: > > There was lot of bugfix releases after 9.1.2 - currently there is > PostgreSQL 9.2.19. I'm sure Pavel meant 9.1.19, not 9.2.19. In any case, be aware that 9.1 goes end of life next year. You should start planning on a major version upgrade now if you haven't already. 9.5 should release in January so you might want to wait for that version. -- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL Data in Trouble? Get it in Treble! http://BlueTreble.com -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance