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 1qc4Op-00DkQd-Km for pgsql-performance@arkaria.postgresql.org; Fri, 01 Sep 2023 13:41:24 +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 1qc4On-00EvDK-DX for pgsql-performance@arkaria.postgresql.org; Fri, 01 Sep 2023 13:41:21 +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 1qc4On-00EvD5-0W for pgsql-performance@lists.postgresql.org; Fri, 01 Sep 2023 13:41:20 +0000 Received: from forward502a.mail.yandex.net ([2a02:6b8:c0e:500:1:45:d181:d502]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qc4Oj-002Lp5-FG for pgsql-performance@lists.postgresql.org; Fri, 01 Sep 2023 13:41:20 +0000 Received: from mail-nwsmtp-mxback-production-main-50.vla.yp-c.yandex.net (mail-nwsmtp-mxback-production-main-50.vla.yp-c.yandex.net [IPv6:2a02:6b8:c15:2a9a:0:640:b8c4:0]) by forward502a.mail.yandex.net (Yandex) with ESMTP id 190715E8B4; Fri, 1 Sep 2023 16:41:14 +0300 (MSK) Received: from mail.yandex.ru (2a02:6b8:c15:2991:0:640:205b:0 [2a02:6b8:c15:2991:0:640:205b:0]) by mail-nwsmtp-mxback-production-main-50.vla.yp-c.yandex.net (mxback/Yandex) with HTTP id BfT2qa0W6qM0-BYvDdB0D; Fri, 01 Sep 2023 16:41:13 +0300 X-Yandex-Fwd: 1 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex.ru; s=mail; t=1693575673; bh=QRQu8JkkfrGWt8vgCGDMl1l1kTSuJOlydQ2sBvm289c=; h=Message-Id:References:Date:Cc:Subject:In-Reply-To:To:From; b=q5ykrBfIpkTSLH7E58I0FCqAwqLknER3nFluFo/rRx/THz9Lo42BmScZm68wy6+vE 99VMYpxEMTgDu+LQvLwevAi5/pPhION52qfRAbCHrIk6rTnXeBU+ci1Cgugq6+Cv30 vT5RaSiRoZdITvtyfDSmKzXhS8Q2RvhKvvr2Rhk8= Authentication-Results: mail-nwsmtp-mxback-production-main-50.vla.yp-c.yandex.net; dkim=pass header.i=@yandex.ru Received: by gf6ne5m4hitewrno.vla.yp-c.yandex.net with HTTP; Fri, 01 Sep 2023 16:41:13 +0300 From: Rondat Flyag To: David Rowley Cc: Jeff Janes , "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:41:13 +0300 Message-Id: <1282241693574959@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 PGRpdj5IaSBEYXZpZC48L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5UaGFuayB5b3Ugc28gbXVjaCBm b3IgeW91ciBoZWxwLiBUaGUgcHJvYmxlbSB3YXMgaW4gdGhlIGRyb3BwZWQgYXNpbnNfc3RhdGlz dGljcyhhc2luX2lkKSBpbmRleC4gSSBoYWQgc2V0IGl0LCBidXQgaXQgd2FzIGRyb3BwZWQgc29t ZWhvdyBkdXJpbmcgdGhlIGR1bXAuIEkgc2V0IGl0IGFnYWluIGFuZGV2ZXJ5dGhpbmcgd29ya3Mg ZmluZSBub3cuPC9kaXY+PGRpdj5UaGFuayB5b3UgYWdhaW4uPC9kaXY+PGRpdj7CoDwvZGl2Pjxk aXY+UC5TLiBUaGVyZSBhcmUgdHdvIGNsb3NlIHRlcm1zOiBBU0lOIGFuZCBJU0JOLiBJIHVzZSBB U0lOIGluIG15IHRhYmxlcywgYnV0IElTQk4gaXMgd2VsbC1rbm93biB0byBwZW9wbGUuIEkgY2hh bmdlZCBBU0lOIHRvIElTQk4gaW4gdGhlIHRleHQgZmlsZXMsIGJ1dCBmb3Jnb3QgdG8gcmVwbGFj ZSB0aGUgbGFzdCB0aW1lLlRoaXMgaXMgd2h5IHRoZSBuYW1lcyBkaWRuJ3QgY29ycmVzcG9uZC48 L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5DaGVlcnMsPC9kaXY+PGRpdj5TZXJnPC9kaXY+PGRpdj7C oDwvZGl2PjxkaXY+MzEuMDguMjAyMywgMDA6NDMsICJEYXZpZCBSb3dsZXkiICZsdDtkZ3Jvd2xl eW1sQGdtYWlsLmNvbSZndDs6PC9kaXY+PGJsb2NrcXVvdGU+PHA+T24gVGh1LCAzMSBBdWcgMjAy MyBhdCAwNjozMiwgUm9uZGF0IEZseWFnICZsdDs8YSBocmVmPSJtYWlsdG86cm9uZGF0Zmx5YWdA eWFuZGV4LnJ1IiByZWw9Im5vb3BlbmVyIG5vcmVmZXJyZXIiPnJvbmRhdGZseWFnQHlhbmRleC5y dTwvYT4mZ3Q7IHdyb3RlOjwvcD48YmxvY2txdW90ZT7CoEkgdHJpZWQgVkFDVVVNIEFOQUxZWkUg Zm9yIHRocmVlIHRhYmxlcywgYnV0IHdpdGhvdXQgc3VjY2Vzcy4gSSBhbHNvIHRyaWVkIHRvIHNl dCBlbmFibGVfc2Vxc2Nhbj1vZmYgYW5kIHRoZSBxdWVyeSB0b29rIGV2ZW4gbW9yZSB0aW1lLiBJ ZiBJIHNldCBlbmFibGVfc29ydD1vZmYgdGhlbiB0aGUgcXVlcnkgdGFrZXMgYSBsb3Qgb2YgdGlt ZSBhbmQgSSBjYW5jZWwgaXQuPGJyIC8+PGJyIC8+wqBQbGVhc2Ugc2VlIHRoZSBhdHRhY2hlZCBx dWVyeSBwbGFucy48L2Jsb2NrcXVvdGU+PHA+PGJyIC8+SXQncyBhIGxpdHRsZSBoYXJkIHRvIGNv bW1lbnQgaGVyZSBhcyBJIGRvbid0IHNlZSB3aGF0IHRoZSBwbGFuIHdhczxiciAvPmJlZm9yZSB3 aGVuIHlvdSB3ZXJlIGhhcHB5IHdpdGggdGhlIHBlcmZvcm1hbmNlLiBJIGFsc28gc2VlIHRoZTxi ciAvPnF1ZXJpZXMgeW91IG1lbnRpb25lZCBpbiB0aGUgaW5pdGlhbCBlbWFpbCBkb24ndCBtYXRj aCB0aGUgcGxhbnMuPGJyIC8+VGhlcmUncyBubyB0YWJsZSBjYWxsZWQgImlzYm5zIiBpbiB0aGUg cXVlcnkuIEkgZ3Vlc3MgdGhpcyBpcyAiYXNpbnMiPzxiciAvPjxiciAvPkxpa2VseSB5b3UgY291 bGQgZ2V0IGEgZmFzdGVyIHBsYW4gaWYgdGhlcmUgd2FzIGFuIGluZGV4IG9uPGJyIC8+YXNpbnNf c3RhdGlzdGljcyAoYXNpbl9pZCkuIFRoYXQgd291bGQgYWxsb3cgYSBxdWVyeSBwbGFuIHRoYXQg c2NhbnM8YnIgLz50aGUgaXNibnNfdmFsdWVfa2V5IGluZGV4IGFuZCBwZXJmb3JtcyBhIHBhcmFt ZXRlcmlzZWQgbmVzdGVkIGxvb3Agb248YnIgLz5hc2luc19zdGF0aXN0aWNzIHVzaW5nIHRoZSBh c2luc19zdGF0aXN0aWNzIChhc2luX2lkKSBpbmRleC4gTG9va2luZzxiciAvPmF0IHlvdXIgc2No ZW1hLCBJIGRvbid0IHNlZSB0aGF0IGluZGV4LCBzbyBpdCdzIHByZXR0eSBoYXJkIHRvIGd1ZXNz PGJyIC8+d2h5IHRoZSBwbGFuIHVzZWQgdG8gYmUgZmFzdGVyLiBFdmVuIGlmIHRoZSBib29rcy9h c2lucyBtZXJnZSBqb2luPGJyIC8+dXNlZCB0byB0YWtlIHBsYWNlIGZpcnN0LCB0aGVyZSdkIGhh dmUgYmVlbiBubyBlZmZpY2llbnQgd2F5IHRvIGpvaW48YnIgLz50byB0aGUgYXNpbnNfc3RhdGlz dGljcyB0YWJsZSBhbmQgcHJlc2VydmUgdGhlIE1lcmdlIEpvaW4ncyBvcmRlciAoSSdtPGJyIC8+ YXNzdW1pbmcgbm9uLXBhcmFtZXRlcml6ZWQgbmVzdGVkIGxvb3BzIHdvdWxkIGJlIGluZWZmaWNp ZW50IGluIHRoaXM8YnIgLz5jYXNlKS4gRG9pbmcgdGhhdCB3b3VsZCBoYXZlIGFsc28gcmVxdWly ZWQgdGhlIGFzaW5zX3N0YXRpc3RpY3M8YnIgLz4oYXNpbl9pZCkgaW5kZXguIEFyZSB5b3Ugc3Vy ZSB0aGF0IGluZGV4IHdhc24ndCBkcm9wcGVkPzxiciAvPjxiciAvPkhvd2V2ZXIsIGxpa2VseSBp dCdzIGEgd2FzdGUgb2YgdGltZSB0byB0cnkgdG8gZmlndXJlIG91dCB3aGF0IHRoZTxiciAvPnBs YW4gdXNlZCB0byBiZS4gQmV0dGVyIHRvIGZvY3VzIG9uIHRyeWluZyB0byBtYWtlIGl0IGZhc3Rl ci4gSTxiciAvPnN1Z2dlc3QgeW91IGNyZWF0ZSB0aGUgYXNpbnNfc3RhdGlzdGljcyAoYXNpbl9p ZCkgaW5kZXguIEhvd2V2ZXIsIEk8YnIgLz5jYW4ndCBzYXkgd2l0aCBhbnkgbGV2ZWwgb2YgY29u ZmlkZW5jZSB0aGF0IHRoZSBwbGFubmVyIHdvdWxkIG9wdCB0bzxiciAvPnVzZSB0aGF0IGluZGV4 IGlmIGl0IGRpZCBleGlzdC4gTG93ZXJpbmcgcmFuZG9tX3BhZ2VfY29zdCBvcjxiciAvPmluY3Jl YXNpbmcgZWZmZWN0aXZlX2NhY2hlX3NpemUgd291bGQgaW5jcmVhc2UgdGhlIGNoYW5jZXMgb2Yg dGhhdC48YnIgLz48YnIgLz5EYXZpZDwvcD48L2Jsb2NrcXVvdGU+