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 1pK7VL-0006GW-8a for pgsql-committers@arkaria.postgresql.org; Tue, 24 Jan 2023 00:49:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pK7VK-0006My-4j for pgsql-committers@arkaria.postgresql.org; Tue, 24 Jan 2023 00:49:38 +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 1pK7VJ-0006M1-Jf for pgsql-committers@lists.postgresql.org; Tue, 24 Jan 2023 00:49:37 +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 1pK7VE-0008CJ-T5 for pgsql-committers@lists.postgresql.org; Tue, 24 Jan 2023 00:49:34 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=v+wyxbacX4tJOiP0ZCbAzlwWroRH6heGQHos1H5OHY8=; b=FXOCBACL6GOfmtNBRkuIzTaUty CsSd/2rI+6bpoAmUJl5hi3gIhu6MjMqTrPqX3ui0o3ZBQJxTMPL3k4BNtDaXXU+17KjCWsKkFAWvk h75eXSWbojWb36zFr0tyv5v3MbxNHUkdirp+QTMjGtSjC56H4f8q2LhoZ8JpHsVguEq1rpsb0r+Y+ 98TT7rKGBvXWfxUA+Aco3Xe7W96ESw2o+9KYRUlg2Jwi0FbpJQn6+dBiDL8n0S2yeUdOWd+B4LMsl UAJUE90cwEi8+JMrBLFeHZE9zskGyUUHqHdWW716IwzGWrW5P807ZcXpbVuNddZCgF6yBe+ZpESFz eGYpw1Uw==; 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 1pK7VE-00060U-D0 for pgsql-committers@lists.postgresql.org; Tue, 24 Jan 2023 00:49:32 +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 1pK7VD-0059mE-Jc for pgsql-committers@lists.postgresql.org; Tue, 24 Jan 2023 00:49:31 +0000 Content-Type: multipart/mixed; boundary="===============5385636736673765597==" MIME-Version: 1.0 From: David Rowley To: pgsql-committers@lists.postgresql.org Subject: pgsql: Use OFFSET 0 instead of ORDER BY to stop subquery pullup X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 24 Jan 2023 00:49:31 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5385636736673765597== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VXNlIE9GRlNFVCAwIGluc3RlYWQgb2YgT1JERVIgQlkgdG8gc3RvcCBzdWJxdWVyeSBwdWxsdXAK CmI3NjJmZWQ2NCByZWNlbnRseSBjaGFuZ2VkIHRoaXMgdGVzdCB0byBwcmV2ZW50IHN1YnF1ZXJ5 IHB1bGx1cCB0byBhbGxvdwp1cyB0byB0ZXN0IE1lbW9pemUgd2l0aCBsYXRlcmFsX3ZhcnMuICBB cyBwb2ludGVkIG91dCBieSBUb20gTGFuZSwgT0ZGU0VUCjAgaXMgb3VyIHN0YW5kYXJkIHdheSBv ZiBwcmV2ZW50aW5nIHN1YnF1ZXJ5IHB1bGx1cHMsIHNvIGRvIGl0IHRoYXQgd2F5Cmluc3RlYWQu CgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzIxNDQ4MTguMTY3NDUxNzA2MUBzc3Mu cGdoLnBhLnVzCkJhY2twYXRjaC10aHJvdWdoOiAxNCwgc2FtZSBhcyBiNzYyZmVkNjQKCkJyYW5j aAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5v cmcvcGcvY29tbWl0ZGlmZi85NTY3Njg2ZWM4MzRlNTBhYjEwYWU4NzJhODM5NGM5YTllNTkwYjBk CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVk L21lbW9pemUub3V0IHwgNCArKy0tCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL21lbW9pemUuc3FsICAg ICAgfCA0ICsrLS0KMiBmaWxlcyBjaGFuZ2VkLCA0IGluc2VydGlvbnMoKyksIDQgZGVsZXRpb25z KC0pCgo= --===============5385636736673765597==--