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 1sWxAM-000fDI-Fq for pgsql-bugs@arkaria.postgresql.org; Thu, 25 Jul 2024 12:01:50 +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 1sWxAL-00EGCf-1a for pgsql-bugs@arkaria.postgresql.org; Thu, 25 Jul 2024 12:01:49 +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 1sWvAm-00DJzE-BZ for pgsql-bugs@lists.postgresql.org; Thu, 25 Jul 2024 09:54:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sWvAk-001NOz-39 for pgsql-bugs@lists.postgresql.org; Thu, 25 Jul 2024 09:54:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=0NsTTNY+AsyLosYIqZWEVPbjexoePjoaeMcZqoJLZ6Q=; b=5fTSdhv6v8mcXq1xEyf4ZA9Cwc 6cr/hA/5QYnHiamnCvv0TfiBoah8vAFigjeEj0abBf5fCpertn10kFuGNQ7ood4WrSLBKKSNQkgZe NEeXgHzdyeNFFuc5RYVIMn4m0/9lfHICMwS5TfCoh/EWPgsBzqrYIo7Y49VeWvjFRudA15o6U+El8 JmFBxnMSZkk409QjLZIjcFASavkkgv4PHZDxWb+pPDV9hRKP3vH9Lohsqc8tfgCF193EPsSRWV3Yv y5YgeKwFryV7bkQy2TygfuTt3PkS84MV8L6X5VOV8wQi9iw7GfdRhu0sQuTT+AM9IlStHEKyK3qgT OH04WGWg==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sWvAi-004HpH-JI for pgsql-bugs@lists.postgresql.org; Thu, 25 Jul 2024 09:54:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sWvAg-005sWX-09 for pgsql-bugs@lists.postgresql.org; Thu, 25 Jul 2024 09:54:02 +0000 Content-Type: multipart/mixed; boundary="===============0399303165210699870==" MIME-Version: 1.0 Subject: BUG #18552: slow query, but using union is ok. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: yunfeng.li.nb@gmail.com Reply-To: yunfeng.li.nb@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 25 Jul 2024 09:53:58 +0000 Message-ID: <18552-c7180ffd32395469@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0399303165210699870== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODU1MgpMb2dnZWQgYnk6ICAgICAgICAgIExpIFl1bmZlbmcKRW1haWwg YWRkcmVzczogICAgICB5dW5mZW5nLmxpLm5iQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246 IDE2LjMKT3BlcmF0aW5nIHN5c3RlbTogICBDRU5UT1MgNwpEZXNjcmlwdGlvbjogICAgICAgIAoK c2xvdywgd2FpdGluZyBmb3IgYSBsb25nIHRpbWUgbm90IHJldHVybjoNCnNlbGVjdCBhLmNfbXJp ZCxhLmNfcGF0aG5hbWUgZnJvbSBzanp4X2JyZWFrZXIgYQ0KICB3aGVyZSAoZXhpc3RzKHNlbGVj dCAqIGZyb20gc2p6eF9kaXNjb25uZWN0b3IgYixzanp4X3RyYW5zZm9ybWVyd2luZGluZwpjDQog ICAgd2hlcmUgYy5jX3Bvd2VydHJhbnNmb3JtZXI9JzExNzA5MzU5MDU2MzI5MjQ5MCcgYW5kCihi LmNfaV9ub2RlPWMuY19pX25vZGUgb3IgYi5jX2pfbm9kZT1jLmNfaV9ub2RlKQ0KICAgIGFuZCAo Yi5jX2lfbm9kZT1hLmNfaV9ub2RlIG9yIGIuY19pX25vZGU9YS5jX2pfbm9kZSBvcgpiLmNfal9u b2RlPWEuY19pX25vZGUgb3IgYi5jX2pfbm9kZT1hLmNfal9ub2RlKSkpDQogb3IgZXhpc3RzKHNl bGVjdCAqIGZyb20gc2p6eF90cmFuc2Zvcm1lcndpbmRpbmcgZg0KICAgd2hlcmUgZi5jX3Bvd2Vy dHJhbnNmb3JtZXI9JzExNzA5MzU5MDU2MzI5MjQ5MCcgYW5kCihmLmNfaV9ub2RlPWEuY19pX25v ZGUgb3IgZi5jX2lfbm9kZT1hLmNfal9ub2RlKSkNCg0KYnV0IHVzaW5nIHVuaW9uLCBpdCBpcyBv azoNCnNlbGVjdCBhLmNfbXJpZCxhLmNfcGF0aG5hbWUgZnJvbSBzanp4X2JyZWFrZXIgYQ0KICB3 aGVyZSAoZXhpc3RzKHNlbGVjdCAqIGZyb20gc2p6eF9kaXNjb25uZWN0b3IgYixzanp4X3RyYW5z Zm9ybWVyd2luZGluZwpjDQogICAgd2hlcmUgYy5jX3Bvd2VydHJhbnNmb3JtZXI9JzExNzA5MzU5 MDU2MzI5MjQ5MCcgYW5kCihiLmNfaV9ub2RlPWMuY19pX25vZGUgb3IgYi5jX2pfbm9kZT1jLmNf aV9ub2RlKQ0KICAgIGFuZCAoYi5jX2lfbm9kZT1hLmNfaV9ub2RlIG9yIGIuY19pX25vZGU9YS5j X2pfbm9kZSBvcgpiLmNfal9ub2RlPWEuY19pX25vZGUgb3IgYi5jX2pfbm9kZT1hLmNfal9ub2Rl KSkpDQp1bmlvbiANCnNlbGVjdCBlLmNfbXJpZCxlLmNfcGF0aG5hbWUgZnJvbSBzanp4X2JyZWFr ZXIgZSB3aGVyZSBleGlzdHMoc2VsZWN0ICogZnJvbQpzanp4X3RyYW5zZm9ybWVyd2luZGluZyBm DQogICB3aGVyZSBmLmNfcG93ZXJ0cmFuc2Zvcm1lcj0nMTE3MDkzNTkwNTYzMjkyNDkwJyBhbmQK KGYuY19pX25vZGU9ZS5jX2lfbm9kZSBvciBmLmNfaV9ub2RlPWUuY19qX25vZGUpKQoK --===============0399303165210699870==--