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 1pWl4X-0000Y9-3R for pgsql-committers@arkaria.postgresql.org; Mon, 27 Feb 2023 21:30:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pWl4V-0006zD-Si for pgsql-committers@arkaria.postgresql.org; Mon, 27 Feb 2023 21:30:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pWl4V-0006z4-LM for pgsql-committers@lists.postgresql.org; Mon, 27 Feb 2023 21:30:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pWl4S-0005HB-J8 for pgsql-committers@lists.postgresql.org; Mon, 27 Feb 2023 21:30:11 +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-0005NL-Jt 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-0011b2-Ux for pgsql-committers@lists.postgresql.org; Mon, 27 Feb 2023 21:30:04 +0000 Content-Type: multipart/mixed; boundary="===============6435700658111831165==" 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 --===============6435700658111831165== 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 N2k2QGF3b3JrMy5hbmFyYXplbC5kZQoKQnJhbmNoCi0tLS0tLQpSRUxfMTRfU1RBQkxFCgpEZXRh aWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9iYTAx OWI0ZGFjZjYzNzQ1OTE0OGYxMzI3ZjkzNDViZmYwMzFkZmUyCgpNb2RpZmllZCBGaWxlcwotLS0t LS0tLS0tLS0tLQpjb250cmliL3Bvc3RncmVzX2Zkdy9leHBlY3RlZC9wb3N0Z3Jlc19mZHcub3V0 IHwgMjYgKysrKysrKystLS0tLS0tLS0tLS0tLS0tLS0KY29udHJpYi9wb3N0Z3Jlc19mZHcvc3Fs L3Bvc3RncmVzX2Zkdy5zcWwgICAgICB8IDE4ICsrKysrKysrLS0tLS0tLS0tLQoyIGZpbGVzIGNo YW5nZWQsIDE2IGluc2VydGlvbnMoKyksIDI4IGRlbGV0aW9ucygtKQoK --===============6435700658111831165==--