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 1qc4Sd-00Dkat-Jh for pgsql-performance@arkaria.postgresql.org; Fri, 01 Sep 2023 13:45:19 +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 1qc4Sc-00Ey6Q-IY for pgsql-performance@arkaria.postgresql.org; Fri, 01 Sep 2023 13:45:18 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qc4Sc-00Ey61-7b for pgsql-performance@lists.postgresql.org; Fri, 01 Sep 2023 13:45:18 +0000 Received: from forward500a.mail.yandex.net ([2a02:6b8:c0e:500:1:45:d181:d500]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qc4SW-002A6Z-Et for pgsql-performance@lists.postgresql.org; Fri, 01 Sep 2023 13:45:16 +0000 Received: from mail-nwsmtp-mxback-production-main-93.vla.yp-c.yandex.net (mail-nwsmtp-mxback-production-main-93.vla.yp-c.yandex.net [IPv6:2a02:6b8:c0f:784:0:640:dd76:0]) by forward500a.mail.yandex.net (Yandex) with ESMTP id 7A4E95E90F; Fri, 1 Sep 2023 16:45:07 +0300 (MSK) Received: from mail.yandex.ru (2a02:6b8:c0f:570e:0:640:edad:0 [2a02:6b8:c0f:570e:0:640:edad:0]) by mail-nwsmtp-mxback-production-main-93.vla.yp-c.yandex.net (mxback/Yandex) with HTTP id 5jT7DZ0W7mI0-cdSWufaI; Fri, 01 Sep 2023 16:45:07 +0300 X-Yandex-Fwd: 1 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex.ru; s=mail; t=1693575907; bh=99Bk/9Oa+OTOYIDx74hB2+myKTIAD/lmwXCYiGhFniU=; h=Message-Id:References:Date:Cc:Subject:In-Reply-To:To:From; b=aDMSnDZhlEaExFd+2bN6Ib7oUihEIZIpdkUD7+h670YbWXzJzyUEf78soVesKOlpA 7hTSZrMYh9M7Uoo8oE+cA0aAgwQKCx0wlRJmgEiuyQyTcgsqBo5OcQl1pK9dEeRnFf 4R41U6oWiPI4voxchTGWNQsaJM5u1lknFQA8k+Hk= Authentication-Results: mail-nwsmtp-mxback-production-main-93.vla.yp-c.yandex.net; dkim=pass header.i=@yandex.ru Received: by megd36izw2gubgrl.vla.yp-c.yandex.net with HTTP; Fri, 01 Sep 2023 16:45:06 +0300 From: Rondat Flyag To: Jeff Janes Cc: "pgsql-performance@lists.postgresql.org" In-Reply-To: References: <32431693330715@mail.yandex.ru> <2854111693335271@mail.yandex.ru> <203321693416472@mail.yandex.ru> Subject: Re: Queries containing ORDER BY and LIMIT started to work slowly MIME-Version: 1.0 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Fri, 01 Sep 2023 16:45:06 +0300 Message-Id: <93991693575711@mail.yandex.ru> Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PGRpdj5IZWxsbyBKZWZmLjwvZGl2PjxkaXY+VGhhbmsgeW91IHRvbyBmb3IgeW91ciBlZmZvcnRz IGFuZCBoZWxwLiBUaGUgcHJvYmxlbSB3YXMgaW4gdGhlIGRyb3BwZWQgaW5kZXggZm9yIGFzaW5z X3N0YXRpc3RpY3MoYXNpbl9pZCkuIEl0IGV4aXN0ZWQsIGJ1dCB3YXMgZHJvcHBlZCBkdXJpbmcg dGhlIGR1bXAgSSBzdXBwb3NlLiBJIGNyZWF0ZWQgaXQgYWdhaW4gYW5kIGV2ZXJ5dGhpbmcgaXMg ZmluZSBub3cuPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+Q2hlZXJzLDwvZGl2PjxkaXY+U2VyZzwv ZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PjMxLjA4LjIwMjMsIDE5OjUyLCAiSmVmZiBKYW5lcyIgJmx0 O2plZmYuamFuZXNAZ21haWwuY29tJmd0Ozo8L2Rpdj48YmxvY2txdW90ZT48ZGl2PjxkaXY+T24g V2VkLCBBdWcgMzAsIDIwMjMgYXQgMTozMeKAr1BNIFJvbmRhdCBGbHlhZyAmbHQ7PGEgaHJlZj0i bWFpbHRvOnJvbmRhdGZseWFnQHlhbmRleC5ydSIgcmVsPSJub29wZW5lciBub3JlZmVycmVyIj5y b25kYXRmbHlhZ0B5YW5kZXgucnU8L2E+Jmd0OyB3cm90ZTo8L2Rpdj48ZGl2PjxibG9ja3F1b3Rl IHN0eWxlPSJib3JkZXItbGVmdC1jb2xvcjpyZ2IoIDIwNCAsIDIwNCAsIDIwNCApO2JvcmRlci1s ZWZ0LXN0eWxlOnNvbGlkO2JvcmRlci1sZWZ0LXdpZHRoOjFweDttYXJnaW46MHB4IDBweCAwcHgg MC44ZXg7cGFkZGluZy1sZWZ0OjFleCI+PGRpdj5IaSBhbmQgdGhhbmsgeW91IGZvciB0aGUgcmVz cG9uc2UuPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+SSB0cmllZCBWQUNVVU0gQU5BTFlaRSBmb3Ig dGhyZWUgdGFibGVzLCBidXQgd2l0aG91dCBzdWNjZXNzLiBJIGFsc28gdHJpZWQgdG8gc2V0IGVu YWJsZV9zZXFzY2FuPW9mZiBhbmQgdGhlIHF1ZXJ5IHRvb2sgZXZlbiBtb3JlIHRpbWUuIElmIEkg c2V0IGVuYWJsZV9zb3J0PW9mZiB0aGVuIHRoZSBxdWVyeSB0YWtlcyBhIGxvdCBvZiB0aW1lIGFu ZCBJIGNhbmNlbCBpdC48L2Rpdj48L2Jsb2NrcXVvdGU+PGRpdj7CoDwvZGl2PjxkaXY+TWF5YmUg eW91IGNvdWxkwqByZXN0b3JlICh0byBhIHRlbXAgc2VydmVyLCBub3QgdGhlIHByb2R1Y3Rpb24p IGEgcGh5c2ljYWwgYmFja3VwIHRha2VuIGZyb20gYmVmb3JlIHRoZSBjaGFuZ2UgaGFwcGVuZWQs IGFuZCBnZXQgYW4gb2xkIHBsYW4gdGhhdCB3YXkuwqAgSSdtIGd1ZXNzaW5nIHRoYXQgc29tZWhv dyBhbiBpbmRleCBnb3QgZHJvcHBlZCBhcm91bmQgdGhlIHNhbWUgdGltZSB5b3UgdG9vayB0aGUg ZHVtcC7CoCBUaGF0IG1pZ2h0IGJlIGEgbG90IG9mIHdvcmssIGFuZCBtYXliZSBpdCB3b3VsZCBq dXN0IGJlIGVhc2llciB0byBvcHRpbWl6ZSB0aGUgY3VycmVudCBxdWVyeSB3aGlsZSBpZ25vcmlu ZyB0aGUgcGFzdC7CoCBCdXQgeW91IHNlZW3CoHRvIGJlIGludGVyZXN0ZWQgaW4gYSByb290LWNh dXNlIGFuYWx5c2lzLCBhbmQgSSBkb24ndCBzZWUgYW55IG90aGVyIHdhecKgdG8gZG8gb25lIG9m IHRob3NlLjwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PldoYXQgSSB3b3VsZCBleHBlY3QgdG8gYmUg dGhlIHdpbm5pbmcgcGxhbiB3b3VsZCBiZSBzb21ldGhpbmcgc29ydC1mcmVlIGxpa2U6PC9kaXY+ PGRpdj7CoDwvZGl2PjxkaXY+TGltaXQ8L2Rpdj48ZGl2PsKgIG1lcmdlIGpvaW48L2Rpdj48ZGl2 PsKgIMKgIGluZGV4IHNjYW4geWllbGRpbmcgYm9va3MgaW4gYXNpbiBvcmRlciAoYWxyZWFkeSBi ZWluZyBkb25lKTwvZGl2PjxkaXY+wqAgwqAgbmVzdGVkIGxvb3A8L2Rpdj48ZGl2PsKgIMKgIMKg IMKgaW5kZXggc2NhbiB5aWVsZGluZ8KgYXNpbnMgaW4gdmFsdWUgb3JkZXI8L2Rpdj48ZGl2PsKg IMKgIMKgIMKgaW5kZXggc2NhbiBwcm9iaW5nwqBhc2luc19zdGF0aXN0aWNzIGRyaXZlbiBiecKg YXNpbnNfc3RhdGlzdGljcy5hc2luX2lkID0gPGEgaHJlZj0iaHR0cDovL2FzaW5zLmlkLyIgcmVs PSJub29wZW5lciBub3JlZmVycmVyIj5hc2lucy5pZDwvYT48L2Rpdj48ZGl2PsKgPC9kaXY+PGRp dj5PciBwb3NzaWJseSBhIDJuZCBuZXN0ZWQgbG9vcCByYXRoZXIgdGhhbiB0aGUgbWVyZ2Ugam9p biBqdXN0IGJlbG93IHRoZSBsaW1pdCwgYnV0IHdpdGggdGhlIHJlc3QgdGhlIHNhbWU8L2Rpdj48 ZGl2PsKgPC9kaXY+PGRpdj5JbiBhZGRpdGlvbiB0byB0aGUgImJvb2tzIiBpbmRleCBhbHJlYWR5 IGV2aWRlbnQgaW4geW91ciBjdXJyZW50IHBsYW4sIHlvdSB3b3VsZCBhbHNvIG5lZWQgYW4gaW5k ZXggbGVhZGluZyB3aXRoIGFzaW5zX3N0YXRpc3RpY3MuYXNpbl9pZCwgYW5kIG9uZSBsZWFkaW5n IHdpdGggYXNpbnMudmFsdWUuwqAgQnV0IGlmIGFsbCB0aG9zZSBpbmRleGVzIGV4aXN0cywgaXQg aXMgaGFyZCB0byBzZWUgd2h5IHNldHRpbmcgZW5hYmxlX3NlcXNjYW49b2ZmwqB3b3VsZG4ndCBo YXZlIGZvcmNlZCB0aGVtIHRvIGJlIHVzZWQuPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+wqBDaGVl cnMsPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+SmVmZjwvZGl2PjwvZGl2PjwvZGl2PjwvYmxvY2tx dW90ZT4=