Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eZYjh-0006YK-4m for pgsql-performance@arkaria.postgresql.org; Thu, 11 Jan 2018 09:01:21 +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 1eZYjg-0001NF-No for pgsql-performance@arkaria.postgresql.org; Thu, 11 Jan 2018 09:01:20 +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 1eZYjg-0001N6-2e for pgsql-performance@lists.postgresql.org; Thu, 11 Jan 2018 09:01:20 +0000 Received: from mail-ve1eur01on0111.outbound.protection.outlook.com ([104.47.1.111] helo=EUR01-VE1-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eZYjR-00015Y-1I for pgsql-performance@lists.postgresql.org; Thu, 11 Jan 2018 09:01:19 +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=W/E5uZ3BSI2rcsPlo4NPJ3cHvcvAxbayVhgcK13ASTs=; b=LX9sciG5pDY/za0AtwCpShMSUHAcVojHalmHXwR0nd6/QLn3gYKNUIhNktSspDwXcJiZns2zt5RPLf2j4W+LeBHO84HCfZfAh3kZb4TzlE2eMuUNRdIxrGUhNtOmiTKdQ+rFbIJzf21tz7Aj325yHbeVRQVFLlCo5t/H8giH7mE= 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:01:01 +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:01:01 +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/njz0LRWiFbSYHbsVhbwABck2A Date: Thu, 11 Jan 2018 09:01:01 +0000 Message-ID: <5A5727CF.9070301@sibvisions.com> References: 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:OhagtxrhuBbfmjqtVmzHRMMT3QRWY8p61g62sTH0l/ALJfFrZ9QWXLG9bCyL2UG59aX4dth5bDEsD5PgsrPk1jlqapzVXYSQaYqHUIXFiusOL39zhQuy++Fmp5OomtqVQxUQW07hmfv6M8HFU6745I8R68v3im/gviHhp7nrxIi9q9hcTJ7WL+dSvJn8GvNuhYY4W7By/CteHu6rjhbqfhXLyJRMu8t6lcPDtgDALCPqT0KaVsklajWRK+bAMrzl x-ms-exchange-antispam-srfa-diagnostics: SSOS; x-ms-office365-filtering-correlation-id: 03b4befc-7dd3-40f4-e91e-08d558d1d6aa 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:; x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(6040470)(2401047)(5005006)(8121501046)(10201501046)(3002001)(93006095)(93001095)(3231023)(944501075)(6041268)(20161123564045)(201703131423095)(20161123555045)(201703061421075)(2016111802025)(20161123562045)(20161123560045)(20161123558120)(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)(979002)(39380400002)(346002)(376002)(366004)(189003)(199004)(40764003)(51874003)(24454002)(80316001)(81166006)(2351001)(2501003)(2906002)(5250100002)(5660300001)(25786009)(6506007)(53546011)(508600001)(65816011)(86362001)(76176011)(97736004)(5640700003)(66066001)(8676002)(81156014)(6436002)(14454004)(7736002)(59450400001)(87266011)(305945005)(102836004)(55236004)(8936002)(99286004)(68736007)(3280700002)(2900100001)(3660700001)(6486002)(6916009)(33656002)(105586002)(6246003)(106356001)(6512007)(53936002)(229853002)(59896002)(36756003)(6116002)(2950100002)(3846002)(969003)(989001)(999001)(1009001)(1019001);DIR:OUT;SFP:1102;SCL:1;SRVR:VI1PR1001MB1165;H:VI1PR1001MB1165.EURPRD10.PROD.OUTLOOK.COM;FPR:;SPF:None;PTR:InfoNoRecords;MX:1;A:1;LANG:en; received-spf: None (protection.outlook.com: sibvisions.com does not designate permitted sender hosts) x-microsoft-antispam-message-info: MtYUuJ8/EAsDvxhT2S5aeMz2OXGCXjSovTZlfgTx0vobI352y7bZYIhBuZukqBMSYp296sY9B7Q2qtZFerhBOQ== spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM Content-Type: text/plain; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: sibvisions.com X-MS-Exchange-CrossTenant-Network-Message-Id: 03b4befc-7dd3-40f4-e91e-08d558d1d6aa X-MS-Exchange-CrossTenant-originalarrivaltime: 11 Jan 2018 09:01:01.4164 (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 SGF2ZSB5b3UgdmVyaWZpZWQgdGhhdCB0aGlzIGlzIGlzbid0IGNhdXNlZCBieSBjb2xkIGZpbGVz eXN0ZW0gY2FjaGVzPw0KDQoNCk9uIDExLjAxLjIwMTggMDk6MTksIFBPVVNTRUwsIEd1aWxsYXVt ZSB3cm90ZToNCj4gSGVsbG8sDQo+IA0KPiAgDQo+IA0KPiBJ4oCZbSBydW5uaW5nIFBvc3RncmVT UUwgOS4zIG9uIFdpbmRvd3MgNyBhbmQgSeKAmW0gaGF2aW5nIGEgcGVyZm9ybWFuY2UNCj4gaXNz dWUgYXQgc3RhcnR1cC4gSSBoYXZlIGluc3RhbGxlZCBQb3N0Z3JlU1FMIGFzIGEgc2VydmljZSB0 aHJvdWdoIFdpbmRvd3MNCj4gaW5zdGFsbGVyLg0KPiANCj4gVGhlIGRhdGFiYXNlIHNpemUgaXMg MyBHbywgd2l0aCAxMjAgdGFibGVzLg0KPiANCj4gIA0KPiANCj4gRXZlcnkgdGltZSBJIHRyeSB0 byBydW4gcXVlcmllcyByaWdodCBhZnRlciBXaW5kb3dzIHN0YXJ0dXAsIGl0IHRha2VzIGENCj4g aHVnZSBhbW91bnQgb2YgdGltZS4NCj4gDQo+IElmIEkgcmVzdGFydCB0aGUgUG9zdGdyZVNRTCBX aW5kb3dzIHNlcnZpY2UsIHF1ZXJpZXMgYXJlIHdheSBmYXN0ZXIuDQo+IA0KPiAgDQo+IA0KPiBJ IGhhdmUgYWN0aXZhdGVkIGRlYnVnIGxvZyBhbmQgaGVyZSBpcyB3aGF0IEkgZ2V0IGJlZm9yZSBX aW5kb3dzIHJlc3RhcnQ6DQo+IA0KPiBkdXJhdGlvbjogMi4wMDAgbXMgIHBhcnNlDQo+IA0KPiBk dXJhdGlvbjogMy4wMDAgbXMgIGJpbmQNCj4gDQo+IGR1cmF0aW9uOiAwLjAwMCBtcyAgZXhlY3V0 ZQ0KPiANCj4gQW5kIGFmdGVyIFdpbmRvd3MgcmVzdGFydDoNCj4gDQo+IGR1cmF0aW9uOiAzNjQu MDAwIG1zICBwYXJzZQ0KPiANCj4gZHVyYXRpb246IDQxNS4wMDAgbXMgIGJpbmQNCj4gDQo+IGR1 cmF0aW9uOiAwLjAwMCBtcyAgZXhlY3V0ZQ0KPiANCj4gDQo+IEZvciBpbmZvcm1hdGlvbiwgdGhl IHRlc3QgcXVlcnkgaXM6DQo+IA0KPiBTRUxFQ1QgdC50eXBsZW4gRlJPTSBwZ19jYXRhbG9nLnBn X3R5cGUgdCwgcGdfY2F0YWxvZy5wZ19uYW1lc3BhY2UgbiBXSEVSRQ0KPiB0LnR5cG5hbWVzcGFj ZT1uLm9pZCBBTkQgdC50eXBuYW1lPSduYW1lJyBBTkQgbi5uc3BuYW1lPSdwZ19jYXRhbG9nJw0K PiANCj4gSXTigJlzIG5vdCByZWxhdGVkIHRvIHRoZSBxdWVyeSBpdHNlbGYgc2luY2Ugb3RoZXIg cXVlcmllcyBnaXZlIHRoZSBzYW1lDQo+IHJlc3VsdCAoZnJvbSAxMHggdG8gMTAweCBsb25nZXIp Lg0KPiANCj4gIA0KPiANCj4gSGVyZSBhcmUgbXkgc2V0dGluZ3MgKGFsbCBsb2cgYW5kIGxvY2Fs ZS1yZWxhdGVkIHNldHRpbmdzIG9taXR0ZWQgb24NCj4gcHVycG9zZSk6DQo+IA0KPiANCj4gYnl0 ZWFfb3V0cHV0DQo+IA0KPiBlc2NhcGUNCj4gDQo+IHNlc3Npb24NCj4gDQo+IA0KPiBjaGVja3Bv aW50X3NlZ21lbnRzDQo+IA0KPiA0NQ0KPiANCj4gY29uZmlndXJhdGlvbiBmaWxlDQo+IA0KPiAN Cj4gY2xpZW50X2VuY29kaW5nDQo+IA0KPiBVTklDT0RFDQo+IA0KPiBzZXNzaW9uDQo+IA0KPiAN Cj4gY2xpZW50X21pbl9tZXNzYWdlcw0KPiANCj4gbm90aWNlDQo+IA0KPiBzZXNzaW9uDQo+IA0K PiANCj4gRGF0ZVN0eWxlDQo+IA0KPiBJU08sIERNWQ0KPiANCj4gc2Vzc2lvbg0KPiANCj4gDQo+ IGRlYnVnX3ByZXR0eV9wcmludA0KPiANCj4gb24NCj4gDQo+IGNvbmZpZ3VyYXRpb24gZmlsZQ0K PiANCj4gDQo+IGRlYnVnX3ByaW50X3BsYW4NCj4gDQo+IG9uDQo+IA0KPiBjb25maWd1cmF0aW9u IGZpbGUNCj4gDQo+IA0KPiBkZWZhdWx0X3RleHRfc2VhcmNoX2NvbmZpZw0KPiANCj4gcGdfY2F0 YWxvZy5mcmVuY2gNCj4gDQo+IGNvbmZpZ3VyYXRpb24gZmlsZQ0KPiANCj4gDQo+IGxpc3Rlbl9h ZGRyZXNzZXMNCj4gDQo+ICoNCj4gDQo+IGNvbmZpZ3VyYXRpb24gZmlsZQ0KPiANCj4gDQo+IGxv Z2dpbmdfY29sbGVjdG9yDQo+IA0KPiBvbg0KPiANCj4gY29uZmlndXJhdGlvbiBmaWxlDQo+IA0K PiANCj4gbWF4X2Nvbm5lY3Rpb25zDQo+IA0KPiAxMDANCj4gDQo+IGNvbmZpZ3VyYXRpb24gZmls ZQ0KPiANCj4gDQo+IG1heF9zdGFja19kZXB0aA0KPiANCj4gMk1CDQo+IA0KPiBlbnZpcm9ubWVu dCB2YXJpYWJsZQ0KPiANCj4gDQo+IHBvcnQNCj4gDQo+IDU0MzINCj4gDQo+IGNvbmZpZ3VyYXRp b24gZmlsZQ0KPiANCj4gDQo+IHNoYXJlZF9idWZmZXJzDQo+IA0KPiAxMjhNQg0KPiANCj4gY29u ZmlndXJhdGlvbiBmaWxlDQo+IA0KPiANCj4gVGltZVpvbmUNCj4gDQo+IEdNVA0KPiANCj4gdXNl cg0KPiANCj4gIA0KPiANCj4gSSBydW4gcXVlcmllcyB0aHJvdWdoIEpEQkMgZHJpdmVyICg5LjMt MTEwMC1qZGJjNC5qYXIpLiBJIGtub3cgdGhhdCB0aGUNCj4gaXNzdWUgaXMgbm90IHJlbGF0ZWQg dG8gdGhlIFBDLCBzaW5jZSBpdCBnaXZlIHRoZSBzYW1lIHJlc3VsdCBvbiBhIGJ1bmNoIG9mDQo+ IGRpZmZlcmVudCBjb21wdXRlcnMuDQo+IA0KPiAgDQo+IA0KPiBJIGhhdmUgdHdvIHF1ZXN0aW9u czoNCj4gDQo+ICogICAgICAgICBXaGF0IGlzIHRoZSBkaWZmZXJlbmNlIGJldHdlZW4gcmVzdGFy dGluZyBQb3N0Z3JlU1FMIHNlcnZpY2UgYW5kDQo+IHJlc3RhcnRpbmcgdGhlIGNvbXB1dGVyPyBJ cyBQb3N0Z3JlU1FMIHJlbHlpbmcgb24gc29tZSBraW5kIG9mIE9TLWxldmVsDQo+IGNhY2hlIG91 dHNpZGUgV2luZG93cyBzZXJ2aWNlPw0KPiANCj4gKiAgICAgICAgIEhvdyBjYW4gSSBkaWcgZG93 biBkZWVwZXIgYW5kIHNlZSB3aGF04oCZcyBjYXVzaW5nIFBvc3RncmVTUUwNCj4gc2xvd2Rvd24/ DQo+IA0KPiAgDQo+IA0KPiBUaGFua3MgaW4gYWR2YW5jZSBmb3IgeW91ciBoZWxwLA0KPiANCj4g QlIsDQo+IA0KPiAgDQo+IA0KPiBHdWlsbGF1bWUgUE9VU1NFTCB8IOKZoFNvZ2V0aSBIaWdoIFRl Y2gNCj4gDQo+ICA8bWFpbHRvOmd1aWxsYXVtZS5wb3Vzc2VsQHNvZ2V0aS5jb20+IGd1aWxsYXVt ZS5wb3Vzc2VsQHNvZ2V0aS5jb20NCj4gDQo+ICANCj4gDQo+ICANCj4gDQo+ICANCj4gDQo+ICAN Cj4gDQo+ICANCj4gDQo+IA0KPiANCj4gDQo+IFRoaXMgbWVzc2FnZSBjb250YWlucyBpbmZvcm1h dGlvbiB0aGF0IG1heSBiZSBwcml2aWxlZ2VkIG9yIGNvbmZpZGVudGlhbCBhbmQgaXMgdGhlIHBy b3BlcnR5IG9mIHRoZSBDYXBnZW1pbmkgR3JvdXAuIEl0IGlzIGludGVuZGVkIG9ubHkgZm9yIHRo ZSBwZXJzb24gdG8gd2hvbSBpdCBpcyBhZGRyZXNzZWQuIElmIHlvdSBhcmUgbm90IHRoZSBpbnRl bmRlZCByZWNpcGllbnQsIHlvdSBhcmUgbm90IGF1dGhvcml6ZWQgdG8gcmVhZCwgcHJpbnQsIHJl dGFpbiwgY29weSwgZGlzc2VtaW5hdGUsIGRpc3RyaWJ1dGUsIG9yIHVzZSB0aGlzIG1lc3NhZ2Ug b3IgYW55IHBhcnQgdGhlcmVvZi4gSWYgeW91IHJlY2VpdmUgdGhpcyBtZXNzYWdlIGluIGVycm9y LCBwbGVhc2Ugbm90aWZ5IHRoZSBzZW5kZXIgaW1tZWRpYXRlbHkgYW5kIGRlbGV0ZSBhbGwgY29w aWVzIG9mIHRoaXMgbWVzc2FnZS4NCj4g