Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dUpOL-0005fq-4K for pgsql-performance@arkaria.postgresql.org; Tue, 11 Jul 2017 07:15:29 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dUpOJ-0000y0-TP for pgsql-performance@arkaria.postgresql.org; Tue, 11 Jul 2017 07:15:27 +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 1dUpOI-0000xh-78 for pgsql-performance@postgresql.org; Tue, 11 Jul 2017 07:15:26 +0000 Received: from relay-ff112.magwien.gv.at ([217.149.228.140]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dUpOA-0003Lx-PN for pgsql-performance@postgresql.org; Tue, 11 Jul 2017 07:15:24 +0000 Received: from localhost (localhost [127.0.0.1]) by relay-ff112.magwien.gv.at (Postfix) with ESMTP id 12AA020624; Tue, 11 Jul 2017 09:17:14 +0200 (CEST) X-Virus-Scanned: by amavisd-new using Sophie and ClamAV at magwien.gv.at Received: from ntex2010j.host.magwien.gv.at (ntex2010j.host.magwien.gv.at [--]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by relay-ff112.magwien.gv.at (Postfix) with ESMTPS id CF6462058F; Tue, 11 Jul 2017 09:17:12 +0200 (CEST) Received: from ntex2010i.host.magwien.gv.at ([169.254.2.67]) by ntex2010j.host.magwien.gv.at ([169.254.4.127]) with mapi id 14.03.0301.000; Tue, 11 Jul 2017 09:15:13 +0200 From: Albe Laurenz To: "'rverghese *EXTERN*'" , "pgsql-performance@postgresql.org" Subject: Re: vacuum analyze affecting query performance Thread-Topic: [PERFORM] vacuum analyze affecting query performance Thread-Index: AQHS+aOm8P/kHH698kWiogEZxjyUTKJONiQg Date: Tue, 11 Jul 2017 07:15:12 +0000 Message-ID: References: <1499707507430-5970681.post@n3.nabble.com> In-Reply-To: <1499707507430-5970681.post@n3.nabble.com> Accept-Language: en-US, de-AT Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 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 cnZlcmdoZXNlIHdyb3RlOg0KPiBXZSBhcmUgb24gUG9zdGdyZXMgOS41LCBh bmQgaGF2ZSBiZWVuIHJ1bm5pbmcgYSBkYWlseSB2YWN1dW0gYW5hbHl6ZSBv biB0aGUNCj4gZW50aXJlIGRhdGFiYXNlIHNpbmNlIDguMg0KPiBUaGUgZGF0 YSBoYXMgZ3Jvd24gZXhwb25lbnRpYWxseSBzaW5jZSwgYW5kIHdlIGFyZSBz ZWVpbmcgdGhhdCBxdWVyaWVzIGFyZQ0KPiBub3cgYmVpbmcgc2lnbmlmaWNh bnRseSBhZmZlY3RlZCB3aGlsZSB0aGUgdmFjdXVtIGFuYWx5emUgcnVucy4g VGhlIHF1ZXJ5DQo+IGRhdGFiYXNlIGlzIGEgU2xvbnkgc2xhdmUuDQo+IFNv IHRoZSBxdWVzdGlvbiBpcywgaXMgdGhpcyB0eXBpY2FsIGJlaGF2aW9yIGFu ZCBzaG91bGQgd2Ugc3RpbGwgYmUgcnVubmluZw0KPiBhIGRhaWx5IHZhY3V1 bSBhbmFseXplIG9uIHRoZSBkYXRhYmFzZT8NCg0KV2hpbGUgVkFDVVVNIHJ1 bnMgb24gdGFibGVzLCB5b3UgY2FuIGV4cGVjdCBwZXJmb3JtYW5jZSB0byBn ZXQgd29yc2UsDQptb3N0bHkgYmVjYXVzZSBvZiBjb250ZW50aW9uIGZvciBJ L08gcmVzb3VyY2VzIChpcyB0aGF0IHRoZSBjYXNlIGZvciB5b3U/KS4NCg0K QXV0b3ZhY3V1bSBoYXMgYmVjb21lICptdWNoKiBiZXR0ZXIgc2luY2UgUG9z dGdyZVNRTCA4LjIuDQoNCklmIHlvdSBjYW5ub3QgZmluZCBhICJxdWlldCB0 aW1lIiBkdXJpbmcgd2hpY2ggeW91IGNhbiBrZWVwIHJ1bm5pbmcgeW91cg0K ZGFpbHkgVkFDVVVNIHdpdGhvdXQgY2F1c2luZyBwcm9ibGVtcywgZG9uJ3Qg ZG8gaXQgYW5kIGdvIHdpdGggYXV0b3ZhY3V1bQ0KYnkgYWxsIG1lYW5zLg0K DQpBdXRvdmFjdXVtIGlzIGxlc3MgZGlzcnVwdGl2ZSB0aGFuIG5vcm1hbCBW QUNVVU0sIGl0IGlzIGRlc2lnbmVkIHRvIG5vdA0KaG9nIHJlc291cmNlcy4N Cg0KSWYgdGhlIGRhdGFiYXNlIGlzIHZlcnkgYnVzeSBhbmQgYXV0b3ZhY3V1 bSBoYXMgcHJvYmxlbXMga2VlcGluZyB1cCwNCnR1bmUgaXQgdG8gYmUgbW9y ZSBhZ2dyZXNzaXZlIChhbmQgaXQgd2lsbCBzdGlsbCBiZSBsZXNzIGRpc3J1 cHRpdmUNCnRoYW4gYSBtYW51YWwgVkFDVVVNKS4NCg0KWW91cnMsDQpMYXVy ZW56IEFsYmUNCgotLSAKU2VudCB2aWEgcGdzcWwtcGVyZm9ybWFuY2UgbWFp bGluZyBsaXN0IChwZ3NxbC1wZXJmb3JtYW5jZUBwb3N0Z3Jlc3FsLm9yZykK VG8gbWFrZSBjaGFuZ2VzIHRvIHlvdXIgc3Vic2NyaXB0aW9uOgpodHRwOi8v d3d3LnBvc3RncmVzcWwub3JnL21haWxwcmVmL3Bnc3FsLXBlcmZvcm1hbmNl Cg==