Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pWl7V-0000jW-5Y for pgsql-committers@arkaria.postgresql.org; Mon, 27 Feb 2023 21:33:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pWl7T-000059-Uj for pgsql-committers@arkaria.postgresql.org; Mon, 27 Feb 2023 21:33:15 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pWl4X-0007Iq-LL for pgsql-committers@lists.postgresql.org; Mon, 27 Feb 2023 21:30:13 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pWl4Q-0000ha-Vj for pgsql-committers@lists.postgresql.org; Mon, 27 Feb 2023 21:30:12 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pWl4P-0005NK-Jw for pgsql-committers@lists.postgresql.org; Mon, 27 Feb 2023 21:30:05 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pWl4N-0011az-US for pgsql-committers@lists.postgresql.org; Mon, 27 Feb 2023 21:30:04 +0000 Content-Type: multipart/mixed; boundary="===============2693063499072169458==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Harden postgres_fdw tests against unexpected cache flushes. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 27 Feb 2023 21:30:04 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2693063499072169458== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SGFyZGVuIHBvc3RncmVzX2ZkdyB0ZXN0cyBhZ2FpbnN0IHVuZXhwZWN0ZWQgY2FjaGUgZmx1c2hl cy4KCnBvc3RncmVzX2ZkdyB3aWxsIGNsb3NlIGl0cyByZW1vdGUgc2Vzc2lvbiBpZiBhbiBzaW52 YWwgY2FjaGUgcmVzZXQKb2NjdXJzLCBzaW5jZSBpdCdzIHBvc3NpYmxlIHRoYXQgdGhhdCBtZWFu cyBzb21lIEZEVyBwYXJhbWV0ZXJzCmNoYW5nZWQuICBXZSBoYWQgdHdvIHRlc3RzIHRoYXQgd2Vy ZSB0cnlpbmcgdG8gZW5zdXJlIHRoYXQgdGhlCnNlc3Npb24gcmVtYWlucyBhbGl2ZSBieSBzZXR0 aW5nIGRlYnVnX2Rpc2NhcmRfY2FjaGVzID0gMDsgYnV0CnRoYXQncyBub3Qgc3VmZmljaWVudC4g IEV2ZW4gdGhvdWdoIHRoZSB0ZXN0cyBzZWVtIHN0YWJsZSBlbm91Z2gKaW4gdGhlIGJ1aWxkZmFy bSwgdGhleSBmbGFwIGEgbG90IHVuZGVyIENJLgoKSW4gdGhlIGZpcnN0IHRlc3QsIHdoaWNoIGlz IGNoZWNraW5nIHRoZSBhYmlsaXR5IHRvIHJlY292ZXIgZnJvbQphIGxvc3QgY29ubmVjdGlvbiwg d2UgY2FuIHN0YWJpbGl6ZSB0aGUgcmVzdWx0cyBieSBqdXN0IG5vdApjYXJpbmcgd2hldGhlciBw Z190ZXJtaW5hdGVfYmFja2VuZCgpIGZpbmRzIGEgdmljdGltIGJhY2tlbmQuCklmIGEgcmVzZXQg ZGlkIGhhcHBlbiwgdGhlcmUgd29uJ3QgYmUgYSBzZXNzaW9uIHRvIHRlcm1pbmF0ZQphbnltb3Jl LCBidXQgdGhlIHRlc3QgY2FuIHByb2NlZWQgYW55d2F5LiAgKEFyZ3VhYmx5LCB3ZSBhcmUKdGhl biBub3QgdGVzdGluZyB0aGUgdW5pbnRlbnRpb25hbC1kaXNjb25uZWN0IGNhc2UsIGJ1dCBhcyBs b25nCmFzIHRoYXQgc2NlbmFyaW8gaXMgZXhlcmNpc2VkIGluIG1vc3QgcnVucyBJIHRoaW5rIGl0 J3MgZmluZTsKdGVzdGluZyB0aGUgcmVzZXQtZHJpdmVuIGNhc2UgaXMgb2YgdmFsdWUgdG9vLikK CkluIHRoZSBzZWNvbmQgdGVzdCwgd2hpY2ggaXMgdHJ5aW5nIHRvIHZlcmlmeSB0aGUgYXBwbGlj YXRpb25fbmFtZQpkaXNwbGF5ZWQgaW4gcGdfc3RhdF9hY3Rpdml0eSBieSBhIHJlbW90ZSBzZXNz aW9uLCB3ZSBoYWQgYSByYWNlCmNvbmRpdGlvbiBpbiB0aGF0IHRoZSByZW1vdGUgc2Vzc2lvbiBt aWdodCBnbyBhd2F5IGJlZm9yZSB3ZSBjYW4KZmV0Y2ggaXRzIHBnX3N0YXRfYWN0aXZpdHkgZW50 cnkuICBXZSBjYW4gY2xvc2UgdGhhdCByYWNlIGFuZCBtYWtlCnRoZSB0ZXN0IG1vcmUgY2VydGFp bmx5IHRlc3Qgd2hhdCBpdCBpbnRlbmRzIHRvIGJ5IGFycmFuZ2luZyB0aGluZ3MKc28gdGhhdCB0 aGUgcmVtb3RlIHNlc3Npb24gaXRzZWxmIGZldGNoZXMgaXRzIHBnX3N0YXRfYWN0aXZpdHkgZW50 cnkKKGJhc2VkIG9uIFBJRCByYXRoZXIgdGhhbiBhIHNvbWV3aGF0LWNpcmN1bGFyIGFzc3VtcHRp b24gYWJvdXQgdGhlCmFwcGxpY2F0aW9uIG5hbWUpLgoKQm90aCB0ZXN0cyBub3cgZGVtb25zdHJh Ymx5IHBhc3MgdW5kZXIgZGVidWdfZGlzY2FyZF9jYWNoZXMgPSAxLApzbyB3ZSBjYW4gcmVtb3Zl IHRoYXQgaGFjay4KCkJhY2stcGF0Y2ggaW50byByZWxldmFudCBiYWNrIGJyYW5jaGVzLgoKRGlz Y3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8yMDIzMDIyNjE5NDM0MC51NDRia2ZneXo2NGM2 N2k2QGF3b3JrMy5hbmFyYXplbC5kZQoKQnJhbmNoCi0tLS0tLQpSRUxfMTVfU1RBQkxFCgpEZXRh aWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9iYzc3 YmU3MTQ1ZTFkZmE5Mjk2Y2QyMTlhMjY5YzQwYjZjMWQ5ZjlkCgpNb2RpZmllZCBGaWxlcwotLS0t LS0tLS0tLS0tLQpjb250cmliL3Bvc3RncmVzX2Zkdy9leHBlY3RlZC9wb3N0Z3Jlc19mZHcub3V0 IHwgOTQgKysrKysrKysrKystLS0tLS0tLS0tLS0tLS0KY29udHJpYi9wb3N0Z3Jlc19mZHcvc3Fs L3Bvc3RncmVzX2Zkdy5zcWwgICAgICB8IDUxICsrKysrKystLS0tLS0tCjIgZmlsZXMgY2hhbmdl ZCwgNjQgaW5zZXJ0aW9ucygrKSwgODEgZGVsZXRpb25zKC0pCgo= --===============2693063499072169458==--