Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eZZZM-0001jo-Bo for pgsql-performance@arkaria.postgresql.org; Thu, 11 Jan 2018 09:54:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eZZZL-00080H-U7 for pgsql-performance@arkaria.postgresql.org; Thu, 11 Jan 2018 09:54:43 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eZZZL-000808-2y for pgsql-performance@lists.postgresql.org; Thu, 11 Jan 2018 09:54:43 +0000 Received: from mail-ve1eur01on0097.outbound.protection.outlook.com ([104.47.1.97] helo=EUR01-VE1-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eZZZF-00055i-G8 for pgsql-performance@lists.postgresql.org; Thu, 11 Jan 2018 09:54:41 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=sibvisions.onmicrosoft.com; s=selector1-sibvisions-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=2XgYMnR3yFZvLQGsNZc4NP1dD0flUDZWGMjtg9uUQNg=; b=EAsDUJiHPKu90R/fp54NhWpXR9GqRnM/hg0maiePFx2oxlHQFafZdR5yeuTqfaZjFkrnVYPr7/NN7tErHkyv5DxUdI78Hc6xqrTX0fYYo1uu0r2EZDa5BVmDZy+SteCr59C8B7H2ClH9A5PJUQqyma/69MnzcQ9Ii3pnBlKaJPc= Received: from VI1PR1001MB1165.EURPRD10.PROD.OUTLOOK.COM (10.168.138.15) by VI1PR1001MB1165.EURPRD10.PROD.OUTLOOK.COM (10.168.138.15) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P256) id 15.20.386.5; Thu, 11 Jan 2018 09:54:33 +0000 Received: from VI1PR1001MB1165.EURPRD10.PROD.OUTLOOK.COM ([fe80::cc21:c3d7:f30d:e162]) by VI1PR1001MB1165.EURPRD10.PROD.OUTLOOK.COM ([fe80::cc21:c3d7:f30d:e162%17]) with mapi id 15.20.0386.008; Thu, 11 Jan 2018 09:54:33 +0000 From: Robert Zenz To: "pgsql-performance@lists.postgresql.org" Subject: Re: Slow queries after Windows startup Thread-Topic: Slow queries after Windows startup Thread-Index: AdOKtOvZbi/njz0LRWiFbSYHbsVhbwABck2AAAApe2AAAbTYgA== Date: Thu, 11 Jan 2018 09:54:32 +0000 Message-ID: <5A573459.8060704@sibvisions.com> References: <5A5727CF.9070301@sibvisions.com> In-Reply-To: Accept-Language: de-AT, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: spf=none (sender IP is ) smtp.mailfrom=robert.zenz@sibvisions.com; x-originating-ip: [213.164.18.106] x-ms-publictraffictype: Email x-microsoft-exchange-diagnostics: 1;VI1PR1001MB1165;7:PhloJrQF4OaPXzzsBKWC7KIA8XyALMhk8tdMfV0NWcwC9FNa2wrVmX9fBarbsHM3bF85/CXOuiNRQJ7wfFgBpdHQUN4XdatTrBo5DFyzR4zrpF5Y7kQjD8ZFjEi8/9wR/FPlV7TsQDsg0bLCKJNVhUpoZ0sTHvKpghifXeeRNDdlYZj67te3uuTXxjzBxAby1+o27LlBh2OYtJl3xo1WNmtuvZVMrBwEDotindV1gj8UxhbK/HX1uchUOpBkQErc x-ms-exchange-antispam-srfa-diagnostics: SSOS; x-ms-office365-filtering-correlation-id: cd2076f7-ae09-4c42-c1e4-08d558d950de x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:(5600026)(4604075)(3008032)(4534020)(4602075)(4603075)(7168020)(4627115)(201702281549075)(2017052603307)(7153060)(7193020);SRVR:VI1PR1001MB1165; x-ms-traffictypediagnostic: VI1PR1001MB1165: x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:(28532068793085)(268704632989789); x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(6040470)(2401047)(8121501046)(5005006)(3231023)(944501075)(93006095)(93001095)(10201501046)(3002001)(6041268)(20161123562045)(20161123560045)(20161123558120)(2016111802025)(201703131423095)(201702281528075)(20161123555045)(201703061421075)(201703061406153)(20161123564045)(6072148)(6043046)(201708071742011);SRVR:VI1PR1001MB1165;BCL:0;PCL:0;RULEID:(100000803101)(100110400095);SRVR:VI1PR1001MB1165; x-forefront-prvs: 0549E6FD50 x-forefront-antispam-report: SFV:NSPM;SFS:(10019020)(39380400002)(39830400003)(376002)(346002)(366004)(396003)(55784002)(199004)(189003)(40764003)(51874003)(24454002)(80316001)(81166006)(2351001)(2501003)(2906002)(5250100002)(5660300001)(25786009)(6506007)(81156014)(53546011)(65816011)(86362001)(76176011)(97736004)(478600001)(5640700003)(8676002)(66066001)(6436002)(7736002)(59450400001)(14454004)(87266011)(966005)(305945005)(102836004)(55236004)(8936002)(99286004)(68736007)(3280700002)(2900100001)(3660700001)(316002)(6486002)(6916009)(6306002)(33656002)(105586002)(6246003)(106356001)(6512007)(53936002)(229853002)(59896002)(6116002)(36756003)(2950100002)(3846002);DIR:OUT;SFP:1102;SCL:1;SRVR:VI1PR1001MB1165;H:VI1PR1001MB1165.EURPRD10.PROD.OUTLOOK.COM;FPR:;SPF:None;PTR:InfoNoRecords;A:1;MX:1;LANG:en; received-spf: None (protection.outlook.com: sibvisions.com does not designate permitted sender hosts) x-microsoft-antispam-message-info: Mf4+nT6kigEpduYwDljL59chi7UsAaOUGUUpT3nlAflPPM0tUzcuvXq72Q82NRjuDC80jtJBXOLWHNReuAYZPQ== spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM Content-Type: text/plain; charset="utf-8" Content-ID: <4A6E64117A0A5D48A7FB547537D8EB45@EURPRD10.PROD.OUTLOOK.COM> Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: sibvisions.com X-MS-Exchange-CrossTenant-Network-Message-Id: cd2076f7-ae09-4c42-c1e4-08d558d950de X-MS-Exchange-CrossTenant-originalarrivaltime: 11 Jan 2018 09:54:32.8855 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: beb1b6aa-9998-4674-9056-cbc4fe8c7cad X-MS-Exchange-Transport-CrossTenantHeadersStamped: VI1PR1001MB1165 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk SSBoYXZlIG5vIGlkZWEgdG8gYmUgaG9uZXN0LCBJIGhhdmVuJ3QgZG9uZSBhbnkgV2luZG93cyBh ZG1pbmlzdHJhdGlvbiBpbiBhIGxvbmcNCnRpbWUuDQoNClRoZSBiZXN0IEkgY291bGQgZmluZCBp cyB0aGlzOg0KDQogKiBodHRwczovL2RvY3MubWljcm9zb2Z0LmNvbS9lbi11cy9zeXNpbnRlcm5h bHMvZG93bmxvYWRzL3JhbW1hcA0KICogaHR0cHM6Ly90ZWNobmV0Lm1pY3Jvc29mdC5jb20vZW4t dXMvbGlicmFyeS9jYzkzODU4OS5hc3B4DQoNCg0KT24gMTEuMDEuMjAxOCAxMDowNiwgUE9VU1NF TCwgR3VpbGxhdW1lIHdyb3RlOg0KPiBObywgSSBoYXZlIG5vdCBjaGVja2VkIGl0Lg0KPiBIb3cg Y2FuIEkgbW9uaXRvciBpdCBvbiBXaW5kb3dzPyBEbyB5b3Uga25vdyBhIHRvb2wgdGhhdCBjYW4g aGVscCBtZT8NCj4gDQo+IFRoYW5rcyENCj4gDQo+IC0tLS0tTWVzc2FnZSBkJ29yaWdpbmUtLS0t LQ0KPiBEZSA6IFJvYmVydCBaZW56IFttYWlsdG86cm9iZXJ0LnplbnpAc2lidmlzaW9ucy5jb21d IA0KPiBFbnZvecOpIDogamV1ZGkgMTEgamFudmllciAyMDE4IDEwOjAxDQo+IMOAIDogcGdzcWwt cGVyZm9ybWFuY2VAbGlzdHMucG9zdGdyZXNxbC5vcmcNCj4gT2JqZXQgOiBSZTogU2xvdyBxdWVy aWVzIGFmdGVyIFdpbmRvd3Mgc3RhcnR1cA0KPiANCj4gSGF2ZSB5b3UgdmVyaWZpZWQgdGhhdCB0 aGlzIGlzIGlzbid0IGNhdXNlZCBieSBjb2xkIGZpbGVzeXN0ZW0gY2FjaGVzPw0KPiANCj4gDQo+ IE9uIDExLjAxLjIwMTggMDk6MTksIFBPVVNTRUwsIEd1aWxsYXVtZSB3cm90ZToNCj4+IEhlbGxv LA0KPj4NCj4+ICANCj4+DQo+PiBJ4oCZbSBydW5uaW5nIFBvc3RncmVTUUwgOS4zIG9uIFdpbmRv d3MgNyBhbmQgSeKAmW0gaGF2aW5nIGEgcGVyZm9ybWFuY2UgDQo+PiBpc3N1ZSBhdCBzdGFydHVw LiBJIGhhdmUgaW5zdGFsbGVkIFBvc3RncmVTUUwgYXMgYSBzZXJ2aWNlIHRocm91Z2ggDQo+PiBX aW5kb3dzIGluc3RhbGxlci4NCj4+DQo+PiBUaGUgZGF0YWJhc2Ugc2l6ZSBpcyAzIEdvLCB3aXRo IDEyMCB0YWJsZXMuDQo+Pg0KPj4gIA0KPj4NCj4+IEV2ZXJ5IHRpbWUgSSB0cnkgdG8gcnVuIHF1 ZXJpZXMgcmlnaHQgYWZ0ZXIgV2luZG93cyBzdGFydHVwLCBpdCB0YWtlcyANCj4+IGEgaHVnZSBh bW91bnQgb2YgdGltZS4NCj4+DQo+PiBJZiBJIHJlc3RhcnQgdGhlIFBvc3RncmVTUUwgV2luZG93 cyBzZXJ2aWNlLCBxdWVyaWVzIGFyZSB3YXkgZmFzdGVyLg0KPj4NCj4+ICANCj4+DQo+PiBJIGhh dmUgYWN0aXZhdGVkIGRlYnVnIGxvZyBhbmQgaGVyZSBpcyB3aGF0IEkgZ2V0IGJlZm9yZSBXaW5k b3dzIHJlc3RhcnQ6DQo+Pg0KPj4gZHVyYXRpb246IDIuMDAwIG1zICBwYXJzZQ0KPj4NCj4+IGR1 cmF0aW9uOiAzLjAwMCBtcyAgYmluZA0KPj4NCj4+IGR1cmF0aW9uOiAwLjAwMCBtcyAgZXhlY3V0 ZQ0KPj4NCj4+IEFuZCBhZnRlciBXaW5kb3dzIHJlc3RhcnQ6DQo+Pg0KPj4gZHVyYXRpb246IDM2 NC4wMDAgbXMgIHBhcnNlDQo+Pg0KPj4gZHVyYXRpb246IDQxNS4wMDAgbXMgIGJpbmQNCj4+DQo+ PiBkdXJhdGlvbjogMC4wMDAgbXMgIGV4ZWN1dGUNCj4+DQo+Pg0KPj4gRm9yIGluZm9ybWF0aW9u LCB0aGUgdGVzdCBxdWVyeSBpczoNCj4+DQo+PiBTRUxFQ1QgdC50eXBsZW4gRlJPTSBwZ19jYXRh bG9nLnBnX3R5cGUgdCwgcGdfY2F0YWxvZy5wZ19uYW1lc3BhY2UgbiANCj4+IFdIRVJFIHQudHlw bmFtZXNwYWNlPW4ub2lkIEFORCB0LnR5cG5hbWU9J25hbWUnIEFORCBuLm5zcG5hbWU9J3BnX2Nh dGFsb2cnDQo+Pg0KPj4gSXTigJlzIG5vdCByZWxhdGVkIHRvIHRoZSBxdWVyeSBpdHNlbGYgc2lu Y2Ugb3RoZXIgcXVlcmllcyBnaXZlIHRoZSBzYW1lIA0KPj4gcmVzdWx0IChmcm9tIDEweCB0byAx MDB4IGxvbmdlcikuDQo+Pg0KPj4gIA0KPj4NCj4+IEhlcmUgYXJlIG15IHNldHRpbmdzIChhbGwg bG9nIGFuZCBsb2NhbGUtcmVsYXRlZCBzZXR0aW5ncyBvbWl0dGVkIG9uDQo+PiBwdXJwb3NlKToN Cj4+DQo+Pg0KPj4gYnl0ZWFfb3V0cHV0DQo+Pg0KPj4gZXNjYXBlDQo+Pg0KPj4gc2Vzc2lvbg0K Pj4NCj4+DQo+PiBjaGVja3BvaW50X3NlZ21lbnRzDQo+Pg0KPj4gNDUNCj4+DQo+PiBjb25maWd1 cmF0aW9uIGZpbGUNCj4+DQo+Pg0KPj4gY2xpZW50X2VuY29kaW5nDQo+Pg0KPj4gVU5JQ09ERQ0K Pj4NCj4+IHNlc3Npb24NCj4+DQo+Pg0KPj4gY2xpZW50X21pbl9tZXNzYWdlcw0KPj4NCj4+IG5v dGljZQ0KPj4NCj4+IHNlc3Npb24NCj4+DQo+Pg0KPj4gRGF0ZVN0eWxlDQo+Pg0KPj4gSVNPLCBE TVkNCj4+DQo+PiBzZXNzaW9uDQo+Pg0KPj4NCj4+IGRlYnVnX3ByZXR0eV9wcmludA0KPj4NCj4+ IG9uDQo+Pg0KPj4gY29uZmlndXJhdGlvbiBmaWxlDQo+Pg0KPj4NCj4+IGRlYnVnX3ByaW50X3Bs YW4NCj4+DQo+PiBvbg0KPj4NCj4+IGNvbmZpZ3VyYXRpb24gZmlsZQ0KPj4NCj4+DQo+PiBkZWZh dWx0X3RleHRfc2VhcmNoX2NvbmZpZw0KPj4NCj4+IHBnX2NhdGFsb2cuZnJlbmNoDQo+Pg0KPj4g Y29uZmlndXJhdGlvbiBmaWxlDQo+Pg0KPj4NCj4+IGxpc3Rlbl9hZGRyZXNzZXMNCj4+DQo+PiAq DQo+Pg0KPj4gY29uZmlndXJhdGlvbiBmaWxlDQo+Pg0KPj4NCj4+IGxvZ2dpbmdfY29sbGVjdG9y DQo+Pg0KPj4gb24NCj4+DQo+PiBjb25maWd1cmF0aW9uIGZpbGUNCj4+DQo+Pg0KPj4gbWF4X2Nv bm5lY3Rpb25zDQo+Pg0KPj4gMTAwDQo+Pg0KPj4gY29uZmlndXJhdGlvbiBmaWxlDQo+Pg0KPj4N Cj4+IG1heF9zdGFja19kZXB0aA0KPj4NCj4+IDJNQg0KPj4NCj4+IGVudmlyb25tZW50IHZhcmlh YmxlDQo+Pg0KPj4NCj4+IHBvcnQNCj4+DQo+PiA1NDMyDQo+Pg0KPj4gY29uZmlndXJhdGlvbiBm aWxlDQo+Pg0KPj4NCj4+IHNoYXJlZF9idWZmZXJzDQo+Pg0KPj4gMTI4TUINCj4+DQo+PiBjb25m aWd1cmF0aW9uIGZpbGUNCj4+DQo+Pg0KPj4gVGltZVpvbmUNCj4+DQo+PiBHTVQNCj4+DQo+PiB1 c2VyDQo+Pg0KPj4gIA0KPj4NCj4+IEkgcnVuIHF1ZXJpZXMgdGhyb3VnaCBKREJDIGRyaXZlciAo OS4zLTExMDAtamRiYzQuamFyKS4gSSBrbm93IHRoYXQgDQo+PiB0aGUgaXNzdWUgaXMgbm90IHJl bGF0ZWQgdG8gdGhlIFBDLCBzaW5jZSBpdCBnaXZlIHRoZSBzYW1lIHJlc3VsdCBvbiBhIA0KPj4g YnVuY2ggb2YgZGlmZmVyZW50IGNvbXB1dGVycy4NCj4+DQo+PiAgDQo+Pg0KPj4gSSBoYXZlIHR3 byBxdWVzdGlvbnM6DQo+Pg0KPj4gKiAgICAgICAgIFdoYXQgaXMgdGhlIGRpZmZlcmVuY2UgYmV0 d2VlbiByZXN0YXJ0aW5nIFBvc3RncmVTUUwgc2VydmljZSBhbmQNCj4+IHJlc3RhcnRpbmcgdGhl IGNvbXB1dGVyPyBJcyBQb3N0Z3JlU1FMIHJlbHlpbmcgb24gc29tZSBraW5kIG9mIA0KPj4gT1Mt bGV2ZWwgY2FjaGUgb3V0c2lkZSBXaW5kb3dzIHNlcnZpY2U/DQo+Pg0KPj4gKiAgICAgICAgIEhv dyBjYW4gSSBkaWcgZG93biBkZWVwZXIgYW5kIHNlZSB3aGF04oCZcyBjYXVzaW5nIFBvc3RncmVT UUwNCj4+IHNsb3dkb3duPw0KPj4NCj4+ICANCj4+DQo+PiBUaGFua3MgaW4gYWR2YW5jZSBmb3Ig eW91ciBoZWxwLA0KPj4NCj4+IEJSLA0KPj4NCj4+ICANCj4+DQo+PiBHdWlsbGF1bWUgUE9VU1NF TCB8IOKZoFNvZ2V0aSBIaWdoIFRlY2gNCj4+DQo+PiAgPG1haWx0bzpndWlsbGF1bWUucG91c3Nl bEBzb2dldGkuY29tPiBndWlsbGF1bWUucG91c3NlbEBzb2dldGkuY29tDQo+Pg0KPj4gIA0KPj4N Cj4+ICANCj4+DQo+PiAgDQo+Pg0KPj4gIA0KPj4NCj4+ICANCj4+DQo+Pg0KPj4NCj4+DQo+PiBU aGlzIG1lc3NhZ2UgY29udGFpbnMgaW5mb3JtYXRpb24gdGhhdCBtYXkgYmUgcHJpdmlsZWdlZCBv ciBjb25maWRlbnRpYWwgYW5kIGlzIHRoZSBwcm9wZXJ0eSBvZiB0aGUgQ2FwZ2VtaW5pIEdyb3Vw LiBJdCBpcyBpbnRlbmRlZCBvbmx5IGZvciB0aGUgcGVyc29uIHRvIHdob20gaXQgaXMgYWRkcmVz c2VkLiBJZiB5b3UgYXJlIG5vdCB0aGUgaW50ZW5kZWQgcmVjaXBpZW50LCB5b3UgYXJlIG5vdCBh dXRob3JpemVkIHRvIHJlYWQsIHByaW50LCByZXRhaW4sIGNvcHksIGRpc3NlbWluYXRlLCBkaXN0 cmlidXRlLCBvciB1c2UgdGhpcyBtZXNzYWdlIG9yIGFueSBwYXJ0IHRoZXJlb2YuIElmIHlvdSBy ZWNlaXZlIHRoaXMgbWVzc2FnZSBpbiBlcnJvciwgcGxlYXNlIG5vdGlmeSB0aGUgc2VuZGVyIGlt bWVkaWF0ZWx5IGFuZCBkZWxldGUgYWxsIGNvcGllcyBvZiB0aGlzIG1lc3NhZ2UuDQo+Pg0KPj4N Cj4+DQo+PiBUaGlzIG1lc3NhZ2UgY29udGFpbnMgaW5mb3JtYXRpb24gdGhhdCBtYXkgYmUgcHJp dmlsZWdlZCBvciBjb25maWRlbnRpYWwgYW5kIGlzIHRoZSBwcm9wZXJ0eSBvZiB0aGUgQ2FwZ2Vt aW5pIEdyb3VwLiBJdCBpcyBpbnRlbmRlZCBvbmx5IGZvciB0aGUgcGVyc29uIHRvIHdob20gaXQg aXMgYWRkcmVzc2VkLiBJZiB5b3UgYXJlIG5vdCB0aGUgaW50ZW5kZWQgcmVjaXBpZW50LCB5b3Ug YXJlIG5vdCBhdXRob3JpemVkIHRvIHJlYWQsIHByaW50LCByZXRhaW4sIGNvcHksIGRpc3NlbWlu YXRlLCBkaXN0cmlidXRlLCBvciB1c2UgdGhpcyBtZXNzYWdlIG9yIGFueSBwYXJ0IHRoZXJlb2Yu IElmIHlvdSByZWNlaXZlIHRoaXMgbWVzc2FnZSBpbiBlcnJvciwgcGxlYXNlIG5vdGlmeSB0aGUg c2VuZGVyIGltbWVkaWF0ZWx5IGFuZCBkZWxldGUgYWxsIGNvcGllcyBvZiB0aGlzIG1lc3NhZ2Uu