Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iRino-0001U9-Li for pgsql-performance@arkaria.postgresql.org; Mon, 04 Nov 2019 20:18:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iRinn-00007Z-2u for pgsql-performance@arkaria.postgresql.org; Mon, 04 Nov 2019 20:18:15 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iRinm-00007M-LF for pgsql-performance@lists.postgresql.org; Mon, 04 Nov 2019 20:18:14 +0000 Received: from us-smtp-delivery-1.mimecast.com ([205.139.110.120] helo=us-smtp-1.mimecast.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1iRinh-0002xS-QH for pgsql-performance@lists.postgresql.org; Mon, 04 Nov 2019 20:18:13 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=motus.com; s=mimecast20180725; t=1572898688; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=s0T+Wes7zR5WlaiI80uL9ggv2CyGoxlkjs8iTrj79OI=; b=NcuOAarE9WsPLPrNHNUIv1mjJ6irkn+/rUhVauICii3NkgqMCjHiIBDHAEE5UoxCZhmp+0 WfMkIbdAkh8j4hIVsQb4SzpAnZdLja1ExOSD/KLynDZl9z0OKmBsqG/jf2BNeHbY1YrpU1 Nd2QxiKH9wokCP1QGYJlTITTuk+OPQ8= Received: from NAM02-CY1-obe.outbound.protection.outlook.com (mail-cys01nam02lp2059.outbound.protection.outlook.com [104.47.37.59]) (Using TLS) by relay.mimecast.com with ESMTP id us-mta-398-sA6nzWzDPc6_z4YTutilEQ-1; Mon, 04 Nov 2019 15:18:06 -0500 Received: from BN7PR02MB3985.namprd02.prod.outlook.com (52.132.222.158) by BN7PR02MB4177.namprd02.prod.outlook.com (52.133.223.28) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.2408.24; Mon, 4 Nov 2019 20:18:03 +0000 Received: from BN7PR02MB3985.namprd02.prod.outlook.com ([fe80::7957:98d1:8384:e6d9]) by BN7PR02MB3985.namprd02.prod.outlook.com ([fe80::7957:98d1:8384:e6d9%4]) with mapi id 15.20.2408.024; Mon, 4 Nov 2019 20:18:03 +0000 From: Scott Rankin To: Peter Geoghegan , Justin Pryzby CC: "pgsql-performance@lists.postgresql.org" Subject: Re: Huge shared hit for small table Thread-Topic: Huge shared hit for small table Thread-Index: AQHVk0d19rM0dki3vUWpR2NbZl4mQad7bW6AgAAC+ID//68lgA== Date: Mon, 4 Nov 2019 20:18:03 +0000 Message-ID: References: <266BF5C6-03DC-404A-9240-00FA081BC0A0@motus.com> <20191104195649.GB4999@telsasoft.com> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [45.56.169.252] x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: eae614da-e2bd-4025-f758-08d7616418db x-ms-traffictypediagnostic: BN7PR02MB4177: x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:8882; x-forefront-prvs: 0211965D06 x-forefront-antispam-report: SFV:NSPM;SFS:(10009020)(4636009)(346002)(396003)(366004)(376002)(136003)(39860400002)(189003)(199004)(6506007)(7736002)(86362001)(25786009)(3846002)(186003)(8676002)(6512007)(256004)(5660300002)(305945005)(486006)(66946007)(66556008)(33656002)(8936002)(66446008)(476003)(64756008)(76116006)(66476007)(81156014)(4326008)(6116002)(14444005)(99286004)(11346002)(36756003)(2616005)(446003)(6246003)(6436002)(478600001)(2906002)(26005)(66066001)(6486002)(81166006)(76176011)(110136005)(14454004)(71200400001)(229853002)(71190400001)(102836004)(316002)(53546011)(14583001);DIR:OUT;SFP:1101;SCL:1;SRVR:BN7PR02MB4177;H:BN7PR02MB3985.namprd02.prod.outlook.com;FPR:;SPF:None;LANG:en;PTR:InfoNoRecords;MX:1;A:1; x-ms-exchange-senderadcheck: 1 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: RuXtIsIi0S1UJ8l13ibm7pURvppA+AN/QGQc9Mz6GE6k/oKvRLp6ROL7D0N9dGCLYBzsWdXw5QxtZwIDVvHfOyGqtHG937x638VrOsomzJ4IBTXT2Nk7bbtJxiMyqJcuowxjEW26AzmB8xIzNJWmr979f/4CGIzEVLmY60VLsqJB14dcw5FRcHKkHTGdzvEX5m/UuECgKJ9JyICNX+49nKmB+Qg7ZGL71CnFGNkokoVoYvdBxddbo7Y5sxFFVzO4lQsDb4aYcS+rAlk9x9+0HJCtSEq77v5y38ZHnhkvHMBVzpkNhGvmlxC+AdUomh8sPJX+WdqNEgwRaBEapZfvDgwrl0YNVD4hvuqokbiAd8YQG0VIYhMKoPsKcIFhIj2MKUAFQGz4DYVm8gdtap2HIsOzeHmMItUmg/w7OsJ0pHMWt3gioHa2qqepYtxtOI8b x-ms-exchange-transport-forked: True Content-ID: MIME-Version: 1.0 X-OriginatorOrg: motus.com X-MS-Exchange-CrossTenant-Network-Message-Id: eae614da-e2bd-4025-f758-08d7616418db X-MS-Exchange-CrossTenant-originalarrivaltime: 04 Nov 2019 20:18:03.7107 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 849c4293-31ae-4825-a834-b8bb5ab65c28 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: TEP1dUVVKjmapddDT6ouEuQpiVcAY8OzLHCf/VaOlzfRWIlzzooLhFNPpdIcz6pwFORcLkx6ZdZRd+ni585E5A== X-MS-Exchange-Transport-CrossTenantHeadersStamped: BN7PR02MB4177 X-MC-Unique: sA6nzWzDPc6_z4YTutilEQ-1 X-Mimecast-Spam-Score: 0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk VGhhbmtzIHRvIEp1c3RpbiBmb3IgdGhlIGNsYXJpZmljYXRpb24gYXJvdW5kIHBnc3RhdGluZGV4 Og0KDQpTdGFnaW5nOg0KDQp2ZXJzaW9uMg0KdHJlZV9sZXZlbDENCmluZGV4X3NpemU0MjU5ODQN CnJvb3RfYmxvY2tfbm8zDQppbnRlcm5hbF9wYWdlczENCmxlYWZfcGFnZXM1MA0KZW1wdHlfcGFn ZXMwDQpkZWxldGVkX3BhZ2VzMA0KYXZnX2xlYWZfZGVuc2l0eTcwLjg2DQpsZWFmX2ZyYWdtZW50 YXRpb24xNg0KDQpQcm9kdWN0aW9uOg0KDQp2ZXJzaW9uMg0KdHJlZV9sZXZlbDENCmluZGV4X3Np emUzNjA0NDgNCnJvb3RfYmxvY2tfbm8zDQppbnRlcm5hbF9wYWdlczENCmxlYWZfcGFnZXM0MQ0K ZW1wdHlfcGFnZXMwDQpkZWxldGVkX3BhZ2VzMQ0KYXZnX2xlYWZfZGVuc2l0eTYwLjQ0DQpsZWFm X2ZyYWdtZW50YXRpb24zOS4wMg0KDQrvu79PbiAxMS80LzE5LCAzOjA3IFBNLCAiUGV0ZXIgR2Vv Z2hlZ2FuIiA8cGdAYm93dC5pZT4gd3JvdGU6DQoNCiAgICBPbiBNb24sIE5vdiA0LCAyMDE5IGF0 IDExOjU2IEFNIEp1c3RpbiBQcnl6YnkgPHByeXpieUB0ZWxzYXNvZnQuY29tPiB3cm90ZToNCiAg ICA+IEkgdGhpbmsgaXQncyBiZWNhdXNlIHNvbWUgaGVhcCBwYWdlcyBhcmUgYmVpbmcgdmlzaXRl ZCBtYW55IHRpbWVzLCBkdWUgdG8gdGhlDQogICAgPiBpbmRleCB0dXBsZXMgYmVpbmcgYmFkbHkg ImZyYWdtZW50ZWQiLiAgTm90ZSwgSSdtIG5vdCB0YWxraW5nIGFib3V0DQogICAgPiBmcmFnbWVu dGF0aW9uIG9mIGluZGV4ICpwYWdlcyosIHdoaWNoIGlzIHdoYXQgcGdzdGF0dHVwbGUgcmVwb3J0 cyAod2hpY2gNCiAgICA+IHdvdWxkbid0IGhhdmUgbmVhcmx5IHNvIGRldHJpbWVudGFsIGVmZmVj dCkuICBJIGNvdWxkIHByb2JhYmx5IHNheSB0aGF0IHRoZQ0KICAgID4gaW5kZXggdHVwbGVzIGFy ZSBiYWRseSAiY29ycmVsYXRlZCIgd2l0aCB0aGUgaGVhcC4NCg0KICAgIEJ1dCB0aGlzIGlzIGEg dW5pcXVlIGluZGV4LCBhbmQgU2NvdHQgaW5kaWNhdGVzIHRoYXQgdGhlIHByb2JsZW0gc2VlbXMN CiAgICB0byBnbyBhd2F5IGZvciBhIHdoaWxlIGZvbGxvd2luZyBhIFJFSU5ERVguDQoNCiAgICA+ IEluIFBHIHYxMiB5b3UgY2FuIHVzZSBSRUlOREVYIENPTkNVUlJFTlRMWSAoYnV0IGJld2FyZSB0 aGVyZSdzIGEgY3Jhc2gNCiAgICA+IGFmZmVjdGluZyBpdHMgcHJvZ3Jlc3MgcmVwb3J0aW5nLCBm aXggdG8gYmUgaW5jbHVkZWQgaW4gdjEyLjEpLg0KDQogICAgUEcgdjEyIHdpbGwgc3RvcmUgQi1U cmVlIGR1cGxpY2F0ZXMgaW4gaGVhcCBUSUQgb3JkZXIsIHNvIGlmIHRoYXQncw0KICAgIHRoZSBw cm9ibGVtIHRoZW4gdXBncmFkaW5nIHRvIHYxMiAoYW5kIFJFSU5ERVhpbmcgaWYgdGhlIHVwZ3Jh ZGUgd2FzDQogICAgcGVyZm9ybWVkIHVzaW5nIHBnX3VwZ3JhZGUpIHdpbGwgZml4IGl0IGZvciBn b29kLg0KDQogICAgLS0NCiAgICBQZXRlciBHZW9naGVnYW4NCg0KDQoNClRoaXMgZW1haWwgbWVz c2FnZSBjb250YWlucyBpbmZvcm1hdGlvbiB0aGF0IE1vdHVzLCBMTEMgY29uc2lkZXJzIGNvbmZp ZGVudGlhbCBhbmQvb3IgcHJvcHJpZXRhcnksIG9yIG1heSBsYXRlciBkZXNpZ25hdGUgYXMgY29u ZmlkZW50aWFsIGFuZCBwcm9wcmlldGFyeS4gSXQgaXMgaW50ZW5kZWQgb25seSBmb3IgdXNlIG9m IHRoZSBpbmRpdmlkdWFsIG9yIGVudGl0eSBuYW1lZCBhYm92ZSBhbmQgc2hvdWxkIG5vdCBiZSBm b3J3YXJkZWQgdG8gYW55IG90aGVyIHBlcnNvbnMgb3IgZW50aXRpZXMgd2l0aG91dCB0aGUgZXhw cmVzcyBjb25zZW50IG9mIE1vdHVzLCBMTEMsIG5vciBzaG91bGQgaXQgYmUgdXNlZCBmb3IgYW55 IHB1cnBvc2Ugb3RoZXIgdGhhbiBpbiB0aGUgY291cnNlIG9mIGFueSBwb3RlbnRpYWwgb3IgYWN0 dWFsIGJ1c2luZXNzIHJlbGF0aW9uc2hpcCB3aXRoIE1vdHVzLCBMTEMuIElmIHRoZSByZWFkZXIg b2YgdGhpcyBtZXNzYWdlIGlzIG5vdCB0aGUgaW50ZW5kZWQgcmVjaXBpZW50LCBvciB0aGUgZW1w bG95ZWUgb3IgYWdlbnQgcmVzcG9uc2libGUgdG8gZGVsaXZlciBpdCB0byB0aGUgaW50ZW5kZWQg cmVjaXBpZW50LCB5b3UgYXJlIGhlcmVieSBub3RpZmllZCB0aGF0IGFueSBkaXNzZW1pbmF0aW9u LCBkaXN0cmlidXRpb24sIG9yIGNvcHlpbmcgb2YgdGhpcyBjb21tdW5pY2F0aW9uIGlzIHN0cmlj dGx5IHByb2hpYml0ZWQuIElmIHlvdSBoYXZlIHJlY2VpdmVkIHRoaXMgY29tbXVuaWNhdGlvbiBp biBlcnJvciwgcGxlYXNlIG5vdGlmeSBzZW5kZXIgaW1tZWRpYXRlbHkgYW5kIGRlc3Ryb3kgdGhl IG9yaWdpbmFsIG1lc3NhZ2UuDQoNCkludGVybmFsIFJldmVudWUgU2VydmljZSByZWd1bGF0aW9u cyByZXF1aXJlIHRoYXQgY2VydGFpbiB0eXBlcyBvZiB3cml0dGVuIGFkdmljZSBpbmNsdWRlIGEg ZGlzY2xhaW1lci4gVG8gdGhlIGV4dGVudCB0aGUgcHJlY2VkaW5nIG1lc3NhZ2UgY29udGFpbnMg YWR2aWNlIHJlbGF0aW5nIHRvIGEgRmVkZXJhbCB0YXggaXNzdWUsIHVubGVzcyBleHByZXNzbHkg c3RhdGVkIG90aGVyd2lzZSB0aGUgYWR2aWNlIGlzIG5vdCBpbnRlbmRlZCBvciB3cml0dGVuIHRv IGJlIHVzZWQsIGFuZCBpdCBjYW5ub3QgYmUgdXNlZCBieSB0aGUgcmVjaXBpZW50IG9yIGFueSBv dGhlciB0YXhwYXllciwgZm9yIHRoZSBwdXJwb3NlIG9mIGF2b2lkaW5nIEZlZGVyYWwgdGF4IHBl bmFsdGllcywgYW5kIHdhcyBub3Qgd3JpdHRlbiB0byBzdXBwb3J0IHRoZSBwcm9tb3Rpb24gb3Ig bWFya2V0aW5nIG9mIGFueSB0cmFuc2FjdGlvbiBvciBtYXR0ZXIgZGlzY3Vzc2VkIGhlcmVpbi4N Cg==