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 1qb3sn-00B2wk-3H for pgsql-performance@arkaria.postgresql.org; Tue, 29 Aug 2023 18:56:09 +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 1qb3sk-00A2aF-J5 for pgsql-performance@arkaria.postgresql.org; Tue, 29 Aug 2023 18:56:06 +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 1qb3sk-00A2ZR-6b for pgsql-performance@lists.postgresql.org; Tue, 29 Aug 2023 18:56:06 +0000 Received: from forward500c.mail.yandex.net ([178.154.239.208]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qb3se-001eKy-Vz for pgsql-performance@lists.postgresql.org; Tue, 29 Aug 2023 18:56:04 +0000 Received: from mail-nwsmtp-mxback-production-main-91.iva.yp-c.yandex.net (mail-nwsmtp-mxback-production-main-91.iva.yp-c.yandex.net [IPv6:2a02:6b8:c0c:18a4:0:640:c7c6:0]) by forward500c.mail.yandex.net (Yandex) with ESMTP id 01C495E5CC; Tue, 29 Aug 2023 21:55:57 +0300 (MSK) Received: from mail.yandex.ru (2a02:6b8:c0c:2fae:0:640:be27:0 [2a02:6b8:c0c:2fae:0:640:be27:0]) by mail-nwsmtp-mxback-production-main-91.iva.yp-c.yandex.net (mxback/Yandex) with HTTP id itVVcG0DjqM0-6RwrwP5q; Tue, 29 Aug 2023 21:55:56 +0300 X-Yandex-Fwd: 1 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex.ru; s=mail; t=1693335356; bh=7DblhFuppgOh8Gls3JVMgBPl5NZ5jdZfpAHIWZ9zQlU=; h=Message-Id:References:Date:Cc:Subject:In-Reply-To:To:From; b=pY5PkPk4JFKWOGDjdsKSrAsDplcwZC+acm4DSfLzPMlWy//62gv75LFeeO9Pg9vNV OEDHRDiRS8EKovPskr8fpDiCzUFyA822NFdZj/fi39az+J0uK9yFJINj9bUb3P76DC 6ssSUNu2VxLIHjk4QC46TWNyV7oOvoKokF/L8HqM= Authentication-Results: mail-nwsmtp-mxback-production-main-91.iva.yp-c.yandex.net; dkim=pass header.i=@yandex.ru Received: by bto67lk6gq4dajfb.iva.yp-c.yandex.net with HTTP; Tue, 29 Aug 2023 21:55:56 +0300 From: Rondat Flyag To: Jeff Janes Cc: "pgsql-performance@lists.postgresql.org" In-Reply-To: References: <32431693330715@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: Tue, 29 Aug 2023 21:55:56 +0300 Message-Id: <2854111693335271@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 PGRpdj5JIHRvb2sgdGhlIGR1bXAganVzdCB0byBzdG9yZSBpdCBvbiBhbm90aGVyIHN0b3JhZ2Ug KGV4dGVybmFsIEhERCkuIEkgZGlkbid0IGRvIGFueXRoaW5nIHdpdGggaXQuPC9kaXY+PGRpdj7C oDwvZGl2PjxkaXY+MjkuMDguMjAyMywgMjE6NDIsICJKZWZmIEphbmVzIiAmbHQ7amVmZi5qYW5l c0BnbWFpbC5jb20mZ3Q7OjwvZGl2PjxibG9ja3F1b3RlPjxkaXY+PGRpdj7CoDwvZGl2PsKgPGRp dj48ZGl2Pk9uIFR1ZSwgQXVnIDI5LCAyMDIzIGF0IDE6NDfigK9QTSBSb25kYXQgRmx5YWcgJmx0 OzxhIGhyZWY9Im1haWx0bzpyb25kYXRmbHlhZ0B5YW5kZXgucnUiIHJlbD0ibm9vcGVuZXIgbm9y ZWZlcnJlciI+cm9uZGF0Zmx5YWdAeWFuZGV4LnJ1PC9hPiZndDsgd3JvdGU6PC9kaXY+PGJsb2Nr cXVvdGUgc3R5bGU9ImJvcmRlci1sZWZ0LWNvbG9yOnJnYiggMjA0ICwgMjA0ICwgMjA0ICk7Ym9y ZGVyLWxlZnQtc3R5bGU6c29saWQ7Ym9yZGVyLWxlZnQtd2lkdGg6MXB4O21hcmdpbjowcHggMHB4 IDBweCAwLjhleDtwYWRkaW5nLWxlZnQ6MWV4Ij48ZGl2PkkgaGF2ZSBhIGxlZ2FjeSBzeXN0ZW0g dGhhdCB1c2VzIGBQb3NncmVzcWwgOS42YCBhbmQgYFVidW50dSAxNi4wNGAuIEV2ZXJ5dGhpbmcg d2FzIGZpbmUgc2V2ZXJhbCBkYXlzIGFnbyBldmVuIHdpdGggc3RhbmRhcmQgUG9zdGdyZXNxbCBz ZXR0aW5ncy4gSSBkdW1wZWQgYSBkYXRhYmFzZSB3aXRoIHRoZSBjb21wcmVzc2lvbiBvcHRpb24g KG1heGltdW0gY29tcHJlc3Npb24gbGV2ZWwgLVogOSkgaW4gb3JkZXIgdG8gaGF2ZSBhIHNtYWxs ZXIgc2l6ZSAoYHBnX2R1bXAgLS1jb21wcmVzcz05IGRhdGFiYXNlX25hbWUgJmd0OyBkYXRhYmFz ZV9uYW1lLnNxbGApLiBBZnRlciB0aGF0IEkgZ290IGEgbG90IG9mIHByb2JsZW1zLjwvZGl2Pjwv YmxvY2txdW90ZT48ZGl2PsKgPC9kaXY+PGRpdj5Zb3UgZGVzY3JpYmUgdGFraW5nIGEgZHVtcCBv ZiB0aGUgZGF0YWJhc2UsIGJ1dCBkb24ndCBkZXNjcmliZSBkb2luZyBhbnl0aGluZyB3aXRoIGl0 LsKgIERpZCB5b3UgcmVwbGFjZSB5b3VyIHN5c3RlbSB3aXRoIG9uZSByZXN0b3JlZCBmcm9tIHRo YXQgZHVtcD/CoCBJZiBzbywgZGlkIHZhY3V1bSBhbmQgYW5hbHl6ZSBhZnRlcndhcmRzPzwvZGl2 PjxkaXY+wqA8L2Rpdj48ZGl2PkNoZWVycyw8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5KZWZmPC9k aXY+PC9kaXY+PC9kaXY+PC9ibG9ja3F1b3RlPg==