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 1iL8UK-0002Qb-EN for pgsql-general@arkaria.postgresql.org; Thu, 17 Oct 2019 16:18:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iL8UI-0004Oj-VZ for pgsql-general@arkaria.postgresql.org; Thu, 17 Oct 2019 16:18:54 +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 1iL8UI-0004OS-IH for pgsql-general@lists.postgresql.org; Thu, 17 Oct 2019 16:18:54 +0000 Received: from smtp4.omnicell.com ([173.254.187.26]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1iL8UA-0001H1-OB for pgsql-general@lists.postgresql.org; Thu, 17 Oct 2019 16:18:52 +0000 Received: from pps.filterd (COLO-PP-A2.omnicell.com [127.0.0.1]) by COLO-PP-A2.omnicell.com (8.16.0.27/8.16.0.27) with SMTP id x9HGEfVD026410 for ; Thu, 17 Oct 2019 09:18:44 -0700 Received: from rtp-ex16-01.omnicell.com (RTP-EX16-01.omnicell.com [10.19.7.22]) by COLO-PP-A2.omnicell.com with ESMTP id 2vprh4gpwb-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128 verify=NOT) for ; Thu, 17 Oct 2019 09:18:44 -0700 From: Reid Thompson To: "pgsql-general@lists.postgresql.org" CC: Reid Thompson Subject: Re: Can you please tell us how set this prefetch attribute in following lines. Thread-Topic: Can you please tell us how set this prefetch attribute in following lines. Thread-Index: AdWE3AANIJTmxTElTWm87BMHe/H6nAATA6yA Date: Thu, 17 Oct 2019 16:18:42 +0000 Message-ID: References: In-Reply-To: Reply-To: Reid Thompson Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Evolution 3.32.5 x-originating-ip: [10.3.28.28] Content-Type: text/plain; charset="utf-8" Content-ID: <70459D7DC78A43419A69889604443B8D@omnicell.com> Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10434:,, definitions=2019-10-17_05:,, signatures=0 X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0 priorityscore=1501 malwarescore=0 suspectscore=0 phishscore=0 bulkscore=0 spamscore=0 clxscore=1011 lowpriorityscore=0 mlxscore=0 impostorscore=0 mlxlogscore=618 adultscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.0.1-1908290000 definitions=main-1910170146 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk T24gVGh1LCAyMDE5LTEwLTE3IGF0IDExOjE2ICswMDAwLCBNIFRhcmtlc2h3YXIgUmFvIHdyb3Rl Og0KPiBbRVhURVJOQUwgU09VUkNFXQ0KPiANCj4gIA0KPiANCj4gSGkgYWxsLA0KPiAgDQo+IEhv dyB0byBmZXRjaCBjZXJ0YWluIG51bWJlciBvZiB0dXBsZXMgZnJvbSBhIHBvc3RncmVzIHRhYmxl Lg0KPiAgDQo+IFNhbWUgSSBhbSBkb2luZyBpbiBvcmFjbGUgdXNpbmcgZm9sbG93aW5nIGxpbmVz IGJ5IHNldHRpbmcgcHJlZmV0Y2ggYXR0cmlidXRlLg0KPiAgDQo+IEZvciBvcmFjbGUNCj4gLy8g UHJlcGFyZSBxdWVyeQ0KPiAgICAgaWYoIE9DSVN0bXRQcmVwYXJlKCBteU9jaVN0YXRlbWVudCwg bXlPY2lFcnJvciwgKHRleHQgKilhU3FsU3RhdGVtZW50LA0KPiAvLyBHZXQgc3RhdGVtZW50IHR5 cGUNCj4gIE9DSUF0dHJHZXQoICh2b2lkICopbXlPY2lTdGF0ZW1lbnQsIE9DSV9IVFlQRV9TVE1U LCAmc3RhdGVtZW50X3R5cGUsIDAsIE9DSV9BVFRSX1NUTVRfVFlQRSwgbXlPY2lFcnJvciApOw0K PiAvLyBTZXQgcHJlZmV0Y2ggY291bnQgICAgICAgDQo+ICAgT0NJQXR0clNldCggbXlPY2lTdGF0 ZW1lbnQsIE9DSV9IVFlQRV9TVE1ULCAmcHJlZmV0Y2gsIDAsIE9DSV9BVFRSX1BSRUZFVENIX1JP V1MsIG15T2NpRXJyb3IgKTsgICANCj4gLy8gRXhlY3V0ZSBxdWVyeQ0KPiBzdGF0dXMgPSBPQ0lT dG10RXhlY3V0ZSggbXlPY2lTZXJ2ZXJDdHgsIG15T2NpU3RhdGVtZW50LCBteU9jaUVycm9yLCBp dGVycywgMCwgTlVMTCwgTlVMTCwgT0NJX0RFRkFVTFQgKTsNCj4gIA0KPiAgDQo+IEZvciBQb3N0 Z3Jlcw0KPiAgDQo+IENhbiB5b3UgcGxlYXNlIHRlbGwgdXMgaG93IHNldCB0aGlzIHByZWZldGNo IGF0dHJpYnV0ZSBpbiBmb2xsb3dpbmcgbGluZXMuIElzIFBRZXhlYyByZXR1cm5zIGFsbCB0aGUg cm93cyBmcm9tIHRoZSB0YWJsZT8NCj4gIA0KPiBteVNxbFJlc3VsdHNQRyA9IFBRZXhlYyhjb25u ZWN0aW9uLCBhU3FsU3RhdGVtZW50KTsNCj4gaWYoKFBRcmVzdWx0U3RhdHVzKG15U3FsUmVzdWx0 c1BHKSA9PSBQR1JFU19GQVRBTF9FUlJPUiApIHx8IChQUXN0YXR1cyhjb25uZWN0aW9uKSAhPSBD T05ORUNUSU9OX09LKSl7fQ0KPiBpZiAoKFBRcmVzdWx0U3RhdHVzKG15U3FsUmVzdWx0c1BHKSA9 PSBQR1JFU19DT01NQU5EX09LKSB8fCAoUFFyZXN1bHRTdGF0dXMobXlTcWxSZXN1bHRzUEcpID09 IFBHUkVTX1RVUExFU19PSykpDQo+ICAgICB7DQo+ICAgICAgICAgbXlOdW1Db2x1bW5zID0gUFFu ZmllbGRzKG15U3FsUmVzdWx0c1BHKTsNCj4gICAgICAgICBteVRvdGFsTnVtYmVyT2ZSb3dzSW5R dWVyeVJlc3VsdCA9IFBRbnR1cGxlcyhteVNxbFJlc3VsdHNQRyk7DQo+ICAgICAgICAgbXlDdXJy ZW50Um93TnVtID0gMCA7DQo+ICAgICB9DQo+IA0KPiAgDQo+IFJlZ2FyZHMNCj4gVGFya2VzaHdh cg0KPiAgDQoNCmRlY2xhcmUgYSBjdXJzb3IgYW5kIGZldGNoDQoNCmh0dHBzOi8vYm9va3MuZ29v Z2xlLmNvbS9ib29rcz9pZD1OYzVaVDJYNW1PY0MmcGc9UEE0MDUmbHBnPVBBNDA1JmRxPXBxZXhl YytmZXRjaCZzb3VyY2U9Ymwmb3RzPThQOHc1SmVtY0wmc2lnPUFDZlUzVTBQT0dHU1AwdFlUcnM1 b3h5a0pkT2VmZmFzcEEmaGw9ZW4mc2E9WCZ2ZWQ9MmFoVUtFd2pldmJtQTJLUGxBaFh1a09BS0hh QklCY29RNkFFd0Nub0VDREVRQVEjdj1vbmVwYWdlJnE9cHFleGVjJTIwZmV0Y2gmZj1mYWxzZQ0K DQoNCg==