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.96) (envelope-from ) id 1vYLkg-001TLi-2i for pgsql-bugs@arkaria.postgresql.org; Wed, 24 Dec 2025 10:05:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vYLkd-004Hih-2i for pgsql-bugs@arkaria.postgresql.org; Wed, 24 Dec 2025 10:05:52 +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.96) (envelope-from ) id 1vYLkd-004HiY-0V for pgsql-bugs@lists.postgresql.org; Wed, 24 Dec 2025 10:05:52 +0000 Received: from out28-45.mail.aliyun.com ([115.124.28.45]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vYLkX-002UJa-35 for pgsql-bugs@lists.postgresql.org; Wed, 24 Dec 2025 10:05:50 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=bitmoe.com; s=default; t=1766570739; h=Message-ID:Date:MIME-Version:Subject:To:From:Content-Type; bh=AUj3XhtCJvoEskYhricl0qple3yI4XUOYU2gQoLzCG0=; b=Up5yNbvtVNsqkO/ak+pkZwc1AOiH5oRzfhzwyLeQVp6zfCFXK57Yr35le51YMONz9NKgrOUPafL8ZJ6XW7fSJTIwqyw6QLSI7rKIw2eNJHM2SvZ/QPiqddPmwL06OejcDmTdbaMib9Wn9zfYUOdkaRzMeg2cP63PFDGG9ZoHpaoBWn8aFSBNicLuYVpeHZ43mSONkBw+bq9gn/yGixSJjRyxPqQBmM4azTW++6QknPqafNXZSlDCM/3PIpYJsb8ClBgAXsUW0Igri9K1D1bg5ZmpA4MlvwDGRLZSqMWruKrraBZE3i0m66QtVZsfzkMhnJTcIABRjITWvr7ryyElWg== Received: from 192.168.1.2(mailfrom:gehaowu@bitmoe.com fp:SMTPD_---.frzi0Bp_1766570736 cluster:ay29) by smtp.aliyun-inc.com; Wed, 24 Dec 2025 18:05:36 +0800 Message-ID: <0f894411-0d2c-4455-8403-f342642e49bc@bitmoe.com> Date: Wed, 24 Dec 2025 18:05:35 +0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized) To: Richard Guo Cc: pgsql-bugs , Tom Lane References: <62af586c-c270-44f3-9c5e-02c81d537e3d.gehaowu@bitmoe.com> <7543464e-d2c6-4778-add0-31a6d60e58ce.gehaowu@bitmoe.com> <9e659ce0-da20-42ed-ada2-5f585a89677e.gehaowu@bitmoe.com> Content-Language: en-US From: Haowu Ge Autocrypt: addr=gehaowu@bitmoe.com; keydata= xjMEZNuFRxYJKwYBBAHaRw8BAQdA5EbpLsVMT+0bvoC967vUta70ziR6u1RggYdSFnfyp2fN HUhhb3d1IEdlIDxnZWhhb3d1QGJpdG1vZS5jb20+wpMEExYIADsCGyMFCwkIBwIGFQoJCAsC BBYCAwECHgECF4AWIQQ4rivClnbnZfsNP316Bh9u3wnYqAUCaUffYgIZAQAKCRB6Bh9u3wnY qNj0AQD6L7NuBgNwAtEGbNBELtpYqBWD07NfpMnbk7bRXg3aBgEA5Urr3sJI7CsL7a0NcgXL 9Y12+3N0lBxWoVhyAhU6TATOOARpQVc+EgorBgEEAZdVAQUBAQdARJTloMiOl200rVhL5XR9 iGlrv94WrOCZaHajvIK0nRkDAQgHwngEGBYKACAWIQQ4rivClnbnZfsNP316Bh9u3wnYqAUC aUFXPgIbDAAKCRB6Bh9u3wnYqEdxAP45chutg1BZX0igoQl8hFmrE8+O65yqPDxLGYcrOD7n EgEA2QEPQk8/NmoJQZ5UfauyWQTmF9D2fcj2yl1ypB0m6QE= Organization: Shenzhen BitMOE Information Technology Co., Ltd. In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------KTB0EReOIXykBdlOVHaMceng" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------KTB0EReOIXykBdlOVHaMceng Content-Type: multipart/mixed; boundary="------------p0dGSe254VW5MOW8FSlUNw0k"; protected-headers="v1" From: Haowu Ge To: Richard Guo Cc: pgsql-bugs , Tom Lane Message-ID: <0f894411-0d2c-4455-8403-f342642e49bc@bitmoe.com> Subject: Re: GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized) References: <62af586c-c270-44f3-9c5e-02c81d537e3d.gehaowu@bitmoe.com> <7543464e-d2c6-4778-add0-31a6d60e58ce.gehaowu@bitmoe.com> <9e659ce0-da20-42ed-ada2-5f585a89677e.gehaowu@bitmoe.com> In-Reply-To: --------------p0dGSe254VW5MOW8FSlUNw0k Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gMTIvMjQvMjUgMTU6NTAsIFJpY2hhcmQgR3VvIHdyb3RlOg0KPiBPbiBUaHUsIERlYyAx OCwgMjAyNSBhdCA1OjU24oCvUE0gUmljaGFyZCBHdW8gPGd1b2ZlbmdsaW51eEBnbWFpbC5j b20+IHdyb3RlOg0KPj4gVXBvbiBjbG9zZXIgbG9vaywgaXQgc2VlbXMgdGhhdCB3ZSBkbyBu b3QgbmVlZCB0aGUgc3ludGFjdGljIHNjb3BlDQo+PiBjaGVjayBhdCBhbGwsIGFzIGxvbmcg YXMgd2UgZW5zdXJlIHRoYXQgcGhudWxsaW5ncmVscyBpcyBlbXB0eS4gIEluDQo+PiB0aGlz IGNhc2UsIHRoZSBQSFYgaXMgZWl0aGVyIGEgbm8tb3AgKGZyb20gYSByZWR1Y2VkIG91dGVy IGpvaW4pIG9yDQo+PiB1c2VkIGZvciBpZGVudGl0eSBzZXBhcmF0aW9uIChncm91cGluZyBz ZXRzKS4gIEluIGVpdGhlciBjYXNlLCB0aGUgUEhWDQo+PiBpcyB0cmFuc3BhcmVudCByZWdh cmRpbmcgdGhlIHZhbHVlLCBzbyBpdCBzaG91bGQgbm90IHByZXZlbnQgdGhlDQo+PiB1bmRl cmx5aW5nIGV4cHJlc3Npb24gZnJvbSBtYXRjaGluZyB0aGUgaW5kZXguDQo+IA0KPiBIZXJl IGlzIHRoZSB1cGRhdGVkIHZlcnNpb24gYWxvbmcgdGhlIGxpbmVzIG9mIHRoaXMgaWRlYS4N Cj4gDQo+IC0gUmljaGFyZA0KDQpUZXN0ZWQgYW5kIHBhc3NlZCBpbiBib3RoIGV4YW1wbGUg YW5kIHByb2R1Y3Rpb24gZW52aXJvbm1lbnRzLiBUaGFuayB5b3UgDQpmb3IgeW91ciB3b3Jr Lg0KDQotLSANClRoYW5rcyAmIEJlc3QgUmVnYXJkcw0K8J+RqOKAjfCfkrsgSGFvd3UgR2Ug KOiRm+ixquatpikgfCDwn4yQIHd3dy5nZWhhb3d1LmNvbSB8IPCfk6EgQkc1RlJHIHwg8J+U kCAweERGMDlEOEE4DQoNCg== --------------p0dGSe254VW5MOW8FSlUNw0k-- --------------KTB0EReOIXykBdlOVHaMceng Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature.asc" -----BEGIN PGP SIGNATURE----- wnsEABYIACMWIQQ4rivClnbnZfsNP316Bh9u3wnYqAUCaUu68AUDAAAAAAAKCRB6Bh9u3wnYqAHu AQDCi4xYGlf5TJcXlyl3sZcAqcH56nh4y0CXkCRX3TyTewD+Ml8ZE1M8PFUpLpgfRM4YhS4EJ+j4 ydwfa8+3u4h+2gc= =tKIC -----END PGP SIGNATURE----- --------------KTB0EReOIXykBdlOVHaMceng--