Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tkmD2-006ie7-KM for pgsql-committers@arkaria.postgresql.org; Wed, 19 Feb 2025 15:42:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tkmD0-00A577-EO for pgsql-committers@arkaria.postgresql.org; Wed, 19 Feb 2025 15:41:58 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tkmBm-00A0rR-17 for pgsql-committers@lists.postgresql.org; Wed, 19 Feb 2025 15:40:42 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tkmBj-001mkv-27 for pgsql-committers@lists.postgresql.org; Wed, 19 Feb 2025 15:40:41 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tkmBi-006HkZ-4m for pgsql-committers@lists.postgresql.org; Wed, 19 Feb 2025 15:40:38 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1tkmBi-0009fq-2I for pgsql-committers@lists.postgresql.org; Wed, 19 Feb 2025 15:40:37 +0000 Content-Type: multipart/mixed; boundary="===============0541652282317690417==" MIME-Version: 1.0 From: Andres Freund To: pgsql-committers@lists.postgresql.org Subject: pgsql: backport: Improve handling of empty query results in BackgroundP X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 19 Feb 2025 15:40:37 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0541652282317690417== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 YmFja3BvcnQ6IEltcHJvdmUgaGFuZGxpbmcgb2YgZW1wdHkgcXVlcnkgcmVzdWx0cyBpbiBCYWNr Z3JvdW5kUHNxbAoKVGhpcyBpcyBhIGJhY2twb3J0IG9mIDcwMjkxYTNjNjZlLiBPcmlnaW5hbGx5 IGl0IHdhcyBvbmx5IGFwcGxpZWQgdG8gbWFzdGVyLApidXQgSSAoQW5kcmVzKSBhbSBwbGFubmlu ZyB0byBmaXggYSBmZXcgYnVncyBpbiBCYWNrZ3JvdW5kUHNxbCB0aGF0IGFyZSBoYXJkZXIKdG8g Zml4IGluIHRoZSBiYWNrYnJhbmNoZXMgd2l0aCB0aGUgb2xkIGJlaGF2aW9yLiBJdCdzIGFsc28g Z2VuZXJhbGx5IGdvb2QgZm9yCnRlc3QgaW5mcmFzdHJ1Y3R1cmUgdG8gYmVoYXZlIHNpbWlsYXJs eSBhY3Jvc3MgYnJhbmNoZXMsIHRvIGF2b2lkIHBhaW4gZHVyaW5nCmJhY2twYXRjaGluZy4gIDcw MjkxYTNjNjZlIGNoYW5nZXMgdGhlIGJlaGF2aW9yIGluIHNvbWUgY2FzZXMsIGJ1dCBhZnRlcgpk aXNjdXNzaW5nIGl0LCB3ZSBhcmUgb2sgd2l0aCB0aGF0LCBpdCBzZWVtcyB1bmxpa2VseSB0aGF0 IHRoZXJlIGFyZQpvdXQtb2YtY29yZSB0ZXN0cyByZWx5aW5nIG9uIHRoZSBwcmlvciBiZWhhdmlv ci4KCkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vaWxjY3R6YjVqdTJndWx2bmFkam1o Z2F0bmt4c2RwYWM2NTJieWIydTNkM3dxeml5dnhAZmJ1cWNnbGtlcjQ2CgpNaWNoYWVsJ3Mgb3Jp Z2luYWwgY29tbWl0IG1lc3NhZ2U6CgpBIG5ld2xpbmUgaXMgbm90IGFkZGVkIGF0IHRoZSBlbmQg b2YgYW4gZW1wdHkgcXVlcnkgcmVzdWx0LCBjYXVzaW5nIHRoZQpiYW5uZXIgb2YgdGhlIGhhcmRj b2RlZCBcZWNobyB0byBub3QgYmUgZGlzY2FyZGVkLiAgVGhpcyB3b3VsZCByZWZsZWN0Cm9uIHNj cmlwdHMgdGhhdCBleHBlY3QgYW4gZW1wdHkgcmVzdWx0IGJ5IHNob3dpbmcgdGhlICJRVUVSWV9T RVBBUkFUT1IiCmluIHRoZSBvdXRwdXQgcmV0dXJuZWQgYmFjayB0byB0aGUgY2FsbGVyLCB3aGlj aCB3YXMgY29uZnVzaW5nLgoKVGhpcyBjb21taXQgY2hhbmdlcyBCYWNrZ3JvdW5kUHNxbDo6cXVl cnkoKSBzbyBhcyBlbXB0eSByZXN1bHRzIGFyZSBhYmxlCnRvIHdvcmsgY29ycmVjdGx5LCBtYWtp bmcgdGhlIGZpcnN0IG5ld2xpbmUgYmVmb3JlIHRoZSBiYW5uZXIgb3B0aW9uYWwsCmJyaW5naW5n IG1vcmUgZmxleGliaWxpdHkuCgpOb3RlIHRoYXQgdGhpcyBjaGFuZ2UgYWZmZWN0cyAwMzdfaW52 YWxpZF9kYXRhYmFzZS5wbCwgd2hlcmUgdGhyZWUKcXVlcmllcyBnZW5lcmF0ZWQgYW4gZW1wdHkg cmVzdWx0LCB3aXRoIHRoZSBzY3JpcHQgcmVseWluZyBvbiB0aGUgZGF0YQpmcm9tIHRoZSBoYXJk Y29kZWQgYmFubmVyIHRvIGV4aXN0IGluIHRoZSBleHBlY3RlZCBvdXRwdXQuICBUaGVzZQpxdWVy aWVzIGFyZSBjaGFuZ2VkIHRvIHVzZSBxdWVyeV9zYWZlKCksIGxlYWRpbmcgdG8gYSBzaW1wbGVy IHNjcmlwdC4KClRoZSBhdXRob3IgaGFzIGFsc28gcHJvcG9zZWQgYSB0ZXN0IGluIGEgZGlmZmVy ZW50IHBhdGNoIHdoZXJlIGVtcHR5CnJlc3VsdHMgd291bGQgZXhpc3Qgd2hlbiB1c2luZyBCYWNr Z3JvdW5kUHNxbC4KCkF1dGhvcjogSmFjb2IgQ2hhbXBpb24KUmV2aWV3ZWQtYnk6IEFuZHJldyBE dW5zdGFuLCBNaWNoYWVsIFBhcXVpZXIKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9D QU9ZbWkrPTYwZGVOMjBXRHlDb0hDaWVjZ2l2SnhyPTk4czdzNy1DOFNrWHdyQ2ZIWGdAbWFpbC5n bWFpbC5jb20KCkJyYW5jaAotLS0tLS0KUkVMXzE2X1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0 dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvZmJmZDM4NjYyZjcyNzM2NjBm ZTQ1ZjU5ZTdhNWU0ZTNlYzlmN2FkYQoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3Jj L3Rlc3QvcGVybC9Qb3N0Z3JlU1FML1Rlc3QvQmFja2dyb3VuZFBzcWwucG0gfCAgNiArKysrLS0K c3JjL3Rlc3QvcmVjb3ZlcnkvdC8wMzdfaW52YWxpZF9kYXRhYmFzZS5wbCAgICAgfCAxNCArKysr Ky0tLS0tLS0tLQoyIGZpbGVzIGNoYW5nZWQsIDkgaW5zZXJ0aW9ucygrKSwgMTEgZGVsZXRpb25z KC0pCgo= --===============0541652282317690417==--