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 1qbPHP-00ByMY-T6 for pgsql-performance@arkaria.postgresql.org; Wed, 30 Aug 2023 17:46:59 +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 1qbPHN-001Hfy-EZ for pgsql-performance@arkaria.postgresql.org; Wed, 30 Aug 2023 17:46:57 +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 1qbPHN-001Hfl-41 for pgsql-performance@lists.postgresql.org; Wed, 30 Aug 2023 17:46:56 +0000 Received: from forward500c.mail.yandex.net ([178.154.239.208]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qbPHF-001yXx-KT for pgsql-performance@lists.postgresql.org; Wed, 30 Aug 2023 17:46:56 +0000 Received: from mail-nwsmtp-mxback-production-main-17.iva.yp-c.yandex.net (mail-nwsmtp-mxback-production-main-17.iva.yp-c.yandex.net [IPv6:2a02:6b8:c0c:32a9:0:640:237f:0]) by forward500c.mail.yandex.net (Yandex) with ESMTP id 3AAE85F114; Wed, 30 Aug 2023 20:46:47 +0300 (MSK) Received: from mail.yandex.ru (2a02:6b8:c0c:1b8f:0:640:a998:0 [2a02:6b8:c0c:1b8f:0:640:a998:0]) by mail-nwsmtp-mxback-production-main-17.iva.yp-c.yandex.net (mxback/Yandex) with HTTP id kkVqDB3ZA8c0-bWB8Lhf7; Wed, 30 Aug 2023 20:46:47 +0300 X-Yandex-Fwd: 1 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex.ru; s=mail; t=1693417607; bh=rCXj9q4XGJv/HNO58OYNVFIe7frFsbYS3Kp8Dt/8n58=; h=Message-Id:References:Date:Cc:Subject:In-Reply-To:To:From; b=XWZtDBkTF+CjxfeWfBna5zgkPI8bUVphjG3GVWkdHPxy3AGtFnugZQLyt+4KOTyu3 4rA+OmAZmbIDyHOJ31pjEtIZVh6sCDI7HNbPiR9IOKm7rpu3LNtLz5Y9yU5Er3fTFg cd1nvB+JGPpl3OlN3yAHHSBGU5fKMMNjmOsBX+V0= Authentication-Results: mail-nwsmtp-mxback-production-main-17.iva.yp-c.yandex.net; dkim=pass header.i=@yandex.ru Received: by xhuxlcg565ilglxh.iva.yp-c.yandex.net with HTTP; Wed, 30 Aug 2023 20:46:46 +0300 From: Rondat Flyag To: Rick Otten Cc: "pgsql-performance@lists.postgresql.org" In-Reply-To: References: <32431693330715@mail.yandex.ru> <2854111693335271@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: Wed, 30 Aug 2023 20:46:46 +0300 Message-Id: <1062241693416677@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 PGRpdj5UaGFua3MgZm9yIHRoZSByZXNwb25zZS48L2Rpdj48ZGl2PlN1cmUsIEkgdGhvdWdodCBh Ym91dCBpdCBhbmQgZXZlbiBib3VnaHQgYW5vdGhlciBkcml2ZS4gVGhlIGN1cnJlbnQgZHJpdmUg aXMgU1NELCBhcyBmYXIgYXMgSSdtIGNvbmNlcm5lZCB3cml0ZSBvcGVyYXRpb25zIGRlZ3JhZGUg U1NEcy48L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5FdmVuIHNvLCB3aHkgb3RoZXIgcXVlcmllcyB3 b3JrIGZpbmU/IFdoeSB0aGUgcXVlcnkgam9pbmluZyB0d28gdGFibGVzIGluc3RlYWQgb2YgdGhy ZWUgd29ya3MgZmluZT88L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5DaGVlcnMsPC9kaXY+PGRpdj5T ZXJnPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+MzAuMDguMjAyMywgMDA6MDcsICJSaWNrIE90dGVu IiAmbHQ7cm90dGVud2luZGZpc2hAZ21haWwuY29tJmd0Ozo8L2Rpdj48YmxvY2txdW90ZT48ZGl2 PjxkaXY+wqA8L2Rpdj7CoDxkaXY+PGRpdj5PbiBUdWUsIEF1ZyAyOSwgMjAyMyBhdCAzOjU34oCv UE0gUm9uZGF0IEZseWFnICZsdDs8YSBocmVmPSJtYWlsdG86cm9uZGF0Zmx5YWdAeWFuZGV4LnJ1 IiByZWw9Im5vb3BlbmVyIG5vcmVmZXJyZXIiPnJvbmRhdGZseWFnQHlhbmRleC5ydTwvYT4mZ3Q7 IHdyb3RlOjwvZGl2PjxibG9ja3F1b3RlIHN0eWxlPSJib3JkZXItbGVmdC1jb2xvcjpyZ2IoIDIw NCAsIDIwNCAsIDIwNCApO2JvcmRlci1sZWZ0LXN0eWxlOnNvbGlkO2JvcmRlci1sZWZ0LXdpZHRo OjFweDttYXJnaW46MHB4IDBweCAwcHggMC44ZXg7cGFkZGluZy1sZWZ0OjFleCI+PGRpdj5JIHRv b2sgdGhlIGR1bXAganVzdCB0byBzdG9yZSBpdCBvbiBhbm90aGVyIHN0b3JhZ2UgKGV4dGVybmFs IEhERCkuIEkgZGlkbid0IGRvIGFueXRoaW5nIHdpdGggaXQuPC9kaXY+PGRpdj7CoDwvZGl2Pjxk aXY+MjkuMDguMjAyMywgMjE6NDIsICJKZWZmIEphbmVzIiAmbHQ7PGEgaHJlZj0ibWFpbHRvOmpl ZmYuamFuZXNAZ21haWwuY29tIiByZWw9Im5vb3BlbmVyIG5vcmVmZXJyZXIiIHRhcmdldD0iX2Js YW5rIj5qZWZmLmphbmVzQGdtYWlsLmNvbTwvYT4mZ3Q7OjwvZGl2PjxibG9ja3F1b3RlPjxkaXY+ PGRpdj7CoDwvZGl2PsKgPGRpdj48ZGl2Pk9uIFR1ZSwgQXVnIDI5LCAyMDIzIGF0IDE6NDfigK9Q TSBSb25kYXQgRmx5YWcgJmx0OzxhIGhyZWY9Im1haWx0bzpyb25kYXRmbHlhZ0B5YW5kZXgucnUi IHJlbD0ibm9vcGVuZXIgbm9yZWZlcnJlciIgdGFyZ2V0PSJfYmxhbmsiPnJvbmRhdGZseWFnQHlh bmRleC5ydTwvYT4mZ3Q7IHdyb3RlOjwvZGl2PjxibG9ja3F1b3RlIHN0eWxlPSJib3JkZXItbGVm dC1jb2xvcjpyZ2IoIDIwNCAsIDIwNCAsIDIwNCApO2JvcmRlci1sZWZ0LXN0eWxlOnNvbGlkO2Jv cmRlci1sZWZ0LXdpZHRoOjFweDttYXJnaW46MHB4IDBweCAwcHggMC44ZXg7cGFkZGluZy1sZWZ0 OjFleCI+PGRpdj5JIGhhdmUgYSBsZWdhY3kgc3lzdGVtIHRoYXQgdXNlcyBgUG9zZ3Jlc3FsIDku NmAgYW5kIGBVYnVudHUgMTYuMDRgLiBFdmVyeXRoaW5nIHdhcyBmaW5lIHNldmVyYWwgZGF5cyBh Z28gZXZlbiB3aXRoIHN0YW5kYXJkIFBvc3RncmVzcWwgc2V0dGluZ3MuIEkgZHVtcGVkIGEgZGF0 YWJhc2Ugd2l0aCB0aGUgY29tcHJlc3Npb24gb3B0aW9uIChtYXhpbXVtIGNvbXByZXNzaW9uIGxl dmVsIC1aIDkpIGluIG9yZGVyIHRvIGhhdmUgYSBzbWFsbGVyIHNpemUgKGBwZ19kdW1wIC0tY29t cHJlc3M9OSBkYXRhYmFzZV9uYW1lICZndDsgZGF0YWJhc2VfbmFtZS5zcWxgKS4gQWZ0ZXIgdGhh dCBJIGdvdCBhIGxvdCBvZiBwcm9ibGVtcy48L2Rpdj48L2Jsb2NrcXVvdGU+PGRpdj7CoDwvZGl2 PjxkaXY+WW91IGRlc2NyaWJlIHRha2luZyBhIGR1bXAgb2YgdGhlIGRhdGFiYXNlLCBidXQgZG9u J3QgZGVzY3JpYmUgZG9pbmcgYW55dGhpbmcgd2l0aCBpdC7CoCBEaWQgeW91IHJlcGxhY2UgeW91 ciBzeXN0ZW0gd2l0aCBvbmUgcmVzdG9yZWQgZnJvbSB0aGF0IGR1bXA/wqAgSWYgc28sIGRpZCB2 YWN1dW0gYW5kIGFuYWx5emUgYWZ0ZXJ3YXJkcz88L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5DaGVl cnMsPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+SmVmZjwvZGl2PjwvZGl2PjwvZGl2PjwvYmxvY2tx dW90ZT48L2Jsb2NrcXVvdGU+PGRpdj7CoDwvZGl2PjxkaXY+U2luY2UgdGhpcyBpcyBhIHZlcnkg b2xkIHN5c3RlbSBhbmQgYmFja3VwcyBhcmUgZmFpcmx5IEkvTyBpbnRlbnNpdmUsIGl0IGlzIHBv c3NpYmxlIHlvdSBoYXZlIGEgZGlzayBnb2luZyBiYWQ/wqAgU29tZXRpbWVzIGFmdGVyIGRvaW5n IGEgYnVuY2ggb2YgSS9PIG9uIGFuIG9sZCBkaXNrLCBpdCB3aWxsIGFjY2VsZXJhdGXCoGl0cyBk ZWNsaW5lLsKgIFlvdSBjb3VsZCBiZSBhYm91dCB0byBsb3NlIGl0IGFsdG9nZXRoZXIuPC9kaXY+ PGRpdj7CoDwvZGl2PjwvZGl2PjwvZGl2PjwvYmxvY2txdW90ZT4=