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 1qOw51-009U6X-PR for pgsql-general@arkaria.postgresql.org; Thu, 27 Jul 2023 08:10:40 +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 1qOw4z-008dGc-Pz for pgsql-general@arkaria.postgresql.org; Thu, 27 Jul 2023 08:10:37 +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 1qOw4y-008dGT-Uz for pgsql-general@lists.postgresql.org; Thu, 27 Jul 2023 08:10:37 +0000 Received: from m1550.mail.126.com ([220.181.15.50]) by magus.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qOw4s-000eon-Qn for pgsql-general@lists.postgresql.org; Thu, 27 Jul 2023 08:10:34 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=126.com; s=s110527; h=Date:From:Subject:Content-Type:MIME-Version: Message-ID; bh=cHTrYN7LfMtSPTvyn2lEE5c6lxmmCgxzyuvKTwRemiU=; b=i AZxs5WXsPbkvIO3c0l7/L/xCG8Fk14NJ2hsXio/fVSUOTVFo5Gf8Q+VvNnUHBJ3e SGd2il5IKn2hdO2ziPArb32ouxPCgkJle2JcAXCoZJkt77cOBZjUtmuoA8iZmhvU XVAU1YfjtB5k3xFqtkpkv3fRdELYSUUB8ClLG3CWyQ= Received: from gzhcoder$126.com ( [222.175.120.219, 211.144.19.63] ) by ajax-webmail-wmsvr50 (Coremail) ; Thu, 27 Jul 2023 16:09:27 +0800 (CST) X-Originating-IP: [222.175.120.219, 211.144.19.63] Date: Thu, 27 Jul 2023 16:09:27 +0800 (CST) From: gzh To: "David Rowley" Cc: "Laurenz Albe" , pgsql-general@lists.postgresql.org Subject: =?GBK?Q?Re:_How_to_improve_the_performance_of_my_SQL_query=A3=BF?= X-Priority: 3 X-Mailer: Coremail Webmail Server Version XT5.0.14 build 20230109(dcb5de15) Copyright (c) 2002-2023 www.mailtech.cn 126com In-Reply-To: References: <6212ea1b.425b.1897221c3cc.Coremail.gzhcoder@126.com> <369ee851ef59bc84190f1631219b5a0c8f7907e9.camel@cybertec.at> <1937d056.71e9.18973a752d0.Coremail.gzhcoder@126.com> <6f3fd2f9.12b3.189761e1ccc.Coremail.gzhcoder@126.com> <35cecf64.4a72.1899129b4b7.Coremail.gzhcoder@126.com> X-NTES-SC: AL_QuySAvifukst4SOaY+kXk0oXj+Y2WsK2vPgv245ROZ00uCrr5SEGUlBYG1br9OSoLRqLnze1SzprzeN3fYBhfo6MoJG9+WPjnc0b0yq+5Wjl Content-Type: multipart/alternative; boundary="----=_Part_77845_1909810054.1690445367328" MIME-Version: 1.0 Message-ID: <5901a5a9.536c.18996654820.Coremail.gzhcoder@126.com> X-Coremail-Locale: zh_CN X-CM-TRANSID: MsqowACHLFs4JsJkd+8JAA--.17760W X-CM-SenderInfo: 5j2ku0xghuqiyswou0bp/1tbiuB+5WWJVnJOmHAABsE X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_77845_1909810054.1690445367328 Content-Type: text/plain; charset=GBK Content-Transfer-Encoding: base64 VGhhbmsgeW91IGZvciB5b3VyIHN1Z2dlc3Rpb24uIApUaGUgZGF0YWJhc2UgaXMgaG9zdGVkIG9u IEFXUyBSRFMsIHdpdGggdGhlIGluc3RhbmNlIGhhdmluZyB2Q1BVPTIgYW5kIFJBTT00R0IuIApD b3VsZCB0aGUgbG93IHBlcmZvcm1hbmNlIGJlIGR1ZSB0byB0aGUgbG93IGNvbmZpZ3VyYXRpb24g b2YgQVdTIFJEUz8gCldlIGFyZSBjb25zaWRlcmluZyB0cnlpbmcgYSBoaWdoZXIgY29uZmlndXJh dGlvbiBpbnN0YW5jZS4KCgoKCgoKCgpBdCAyMDIzLTA3LTI3IDExOjM2OjIwLCAiRGF2aWQgUm93 bGV5IiA8ZGdyb3dsZXltbEBnbWFpbC5jb20+IHdyb3RlOgo+T24gV2VkLCAyNiBKdWwgMjAyMyBh dCAxOTo0NiwgZ3poIDxnemhjb2RlckAxMjYuY29tPiB3cm90ZToKPj4gUVVFUlkgUExBTiAoZW5h YmxlX3NlcXNjYW49b24pCj4KPj4gRXhlY3V0aW9uIFRpbWU6IDE2NzE4My4xMzMgbXMKPgo+PiBR VUVSWSBQTEFOIChlbmFibGVfc2Vxc2Nhbj1vZmYpCj4KPj4gRXhlY3V0aW9uIFRpbWU6IDIyMzIw LjE1MyBtcwo+Cj5lZmZlY3RpdmVfY2FjaGVfc2l6ZSBhbmQgcmFuZG9tX3BhZ2VfY29zdCBhcmUg dGhlIHNldHRpbmdzIHlvdSBzaG91bGQKPmJlIGFkanVzdGluZyB0byBjb2F4IHRoZSBwbGFubmVy IGludG8gdXNpbmcgdGhlIGluZGV4Lgo+Cj5BIHJ1bGUgb2YgdGh1bWIgZm9yIGVmZmVjdGl2ZV9j YWNoZV9zaXplIHdvdWxkIGJlIHRvIHNldCBpdCB0byBhYm91dAo+NzUlIG9mIFJBTS4gVGhlcmUg YXJlIGNlcnRhaW5seSBjYXNlcyB3aGVyZSBsb3dlciB3b3VsZCBtYWtlIG1vcmUKPnNlbnNlLCBj ZXJ0YWlubHksIDc1JSB3aWxsIG1ha2UgbW9yZSBzZW5zZSB0aGFuIHRoZSBkZWZhdWx0IDRHQiB2 YWx1ZQo+aW4gdGhlIG1ham9yaXR5IG9mIGNhc2VzLgo+Cj5Gb3IgcmFuZG9tX3BhZ2VfY29zdCwg dGhlIGRlZmF1bHQgb2YgNC4wIGhhcyBiZWVuIHRoZSBkZWZhdWx0IHNpbmNlCj5IRERzIHdlcmUg Y29tbW9uLiBTU0RzIGFyZSBjb21tb24gbm93IGFuZCwgY29tcGFyYXRpdmVseSB0byBzZXF1ZW50 aWFsCj5JL08sIHRoZWlyIHJhbmRvbSBJL08gaXMgZmFzdGVyIHRoYW4gdGhhdCBvZiBhbiBIREQs IHNvIHlvdSBtYXkgZ2V0Cj5iZXR0ZXIgcmVzdWx0cyBieSBsb3dlcmluZyByYW5kb21fcGFnZV9j b3N0Lgo+Cj5EYXZpZAo= ------=_Part_77845_1909810054.1690445367328 Content-Type: text/html; charset=GBK Content-Transfer-Encoding: base64 PGRpdiBzdHlsZT0ibGluZS1oZWlnaHQ6MS43O2NvbG9yOiMwMDAwMDA7Zm9udC1zaXplOjE0cHg7 Zm9udC1mYW1pbHk6QXJpYWwiPjxkaXYgc3R5bGU9Im1hcmdpbjogMDsiPjxzcGFuIHN0eWxlPSJj b2xvcjogcmdiKDE3LCAyNCwgMzkpOyBmb250LWZhbWlseTogJnF1b3Q7QWxiZXJ0IHNhbnMmcXVv dDssIHVpLXNhbnMtc2VyaWYsIHN5c3RlbS11aSwgLWFwcGxlLXN5c3RlbSwgQmxpbmtNYWNTeXN0 ZW1Gb250LCAmcXVvdDtTZWdvZSBVSSZxdW90OywgUm9ib3RvLCAmcXVvdDtIZWx2ZXRpY2EgTmV1 ZSZxdW90OywgQXJpYWwsICZxdW90O05vdG8gU2FucyZxdW90Oywgc2Fucy1zZXJpZiwgJnF1b3Q7 QXBwbGUgQ29sb3IgRW1vamkmcXVvdDssICZxdW90O1NlZ29lIFVJIEVtb2ppJnF1b3Q7LCAmcXVv dDtTZWdvZSBVSSBTeW1ib2wmcXVvdDssICZxdW90O05vdG8gQ29sb3IgRW1vamkmcXVvdDs7IGZv bnQtc2l6ZTogbWVkaXVtOyI+VGhhbmsgeW91IGZvciB5b3VyIHN1Z2dlc3Rpb24uJm5ic3A7PC9z cGFuPjwvZGl2PjxkaXYgc3R5bGU9Im1hcmdpbjogMDsiPjxzcGFuIHN0eWxlPSJjb2xvcjogcmdi KDE3LCAyNCwgMzkpOyBmb250LWZhbWlseTogJnF1b3Q7QWxiZXJ0IHNhbnMmcXVvdDssIHVpLXNh bnMtc2VyaWYsIHN5c3RlbS11aSwgLWFwcGxlLXN5c3RlbSwgQmxpbmtNYWNTeXN0ZW1Gb250LCAm cXVvdDtTZWdvZSBVSSZxdW90OywgUm9ib3RvLCAmcXVvdDtIZWx2ZXRpY2EgTmV1ZSZxdW90Oywg QXJpYWwsICZxdW90O05vdG8gU2FucyZxdW90Oywgc2Fucy1zZXJpZiwgJnF1b3Q7QXBwbGUgQ29s b3IgRW1vamkmcXVvdDssICZxdW90O1NlZ29lIFVJIEVtb2ppJnF1b3Q7LCAmcXVvdDtTZWdvZSBV SSBTeW1ib2wmcXVvdDssICZxdW90O05vdG8gQ29sb3IgRW1vamkmcXVvdDs7IGZvbnQtc2l6ZTog bWVkaXVtOyI+VGhlIGRhdGFiYXNlIGlzIGhvc3RlZCBvbiBBV1MgUkRTLCB3aXRoIHRoZSBpbnN0 YW5jZSBoYXZpbmcgdkNQVT0yIGFuZCBSQU09NEdCLiZuYnNwOzwvc3Bhbj48L2Rpdj48ZGl2IHN0 eWxlPSJtYXJnaW46IDA7Ij48c3BhbiBzdHlsZT0iY29sb3I6IHJnYigxNywgMjQsIDM5KTsgZm9u dC1mYW1pbHk6ICZxdW90O0FsYmVydCBzYW5zJnF1b3Q7LCB1aS1zYW5zLXNlcmlmLCBzeXN0ZW0t dWksIC1hcHBsZS1zeXN0ZW0sIEJsaW5rTWFjU3lzdGVtRm9udCwgJnF1b3Q7U2Vnb2UgVUkmcXVv dDssIFJvYm90bywgJnF1b3Q7SGVsdmV0aWNhIE5ldWUmcXVvdDssIEFyaWFsLCAmcXVvdDtOb3Rv IFNhbnMmcXVvdDssIHNhbnMtc2VyaWYsICZxdW90O0FwcGxlIENvbG9yIEVtb2ppJnF1b3Q7LCAm cXVvdDtTZWdvZSBVSSBFbW9qaSZxdW90OywgJnF1b3Q7U2Vnb2UgVUkgU3ltYm9sJnF1b3Q7LCAm cXVvdDtOb3RvIENvbG9yIEVtb2ppJnF1b3Q7OyBmb250LXNpemU6IG1lZGl1bTsiPkNvdWxkIHRo ZSBsb3cgcGVyZm9ybWFuY2UgYmUgZHVlIHRvIHRoZSBsb3cgY29uZmlndXJhdGlvbiBvZiBBV1Mg UkRTPyZuYnNwOzwvc3Bhbj48L2Rpdj48ZGl2IHN0eWxlPSJtYXJnaW46IDA7Ij48c3BhbiBzdHls ZT0iY29sb3I6IHJnYigxNywgMjQsIDM5KTsgZm9udC1mYW1pbHk6ICZxdW90O0FsYmVydCBzYW5z JnF1b3Q7LCB1aS1zYW5zLXNlcmlmLCBzeXN0ZW0tdWksIC1hcHBsZS1zeXN0ZW0sIEJsaW5rTWFj U3lzdGVtRm9udCwgJnF1b3Q7U2Vnb2UgVUkmcXVvdDssIFJvYm90bywgJnF1b3Q7SGVsdmV0aWNh IE5ldWUmcXVvdDssIEFyaWFsLCAmcXVvdDtOb3RvIFNhbnMmcXVvdDssIHNhbnMtc2VyaWYsICZx dW90O0FwcGxlIENvbG9yIEVtb2ppJnF1b3Q7LCAmcXVvdDtTZWdvZSBVSSBFbW9qaSZxdW90Oywg JnF1b3Q7U2Vnb2UgVUkgU3ltYm9sJnF1b3Q7LCAmcXVvdDtOb3RvIENvbG9yIEVtb2ppJnF1b3Q7 OyBmb250LXNpemU6IG1lZGl1bTsiPldlIGFyZSBjb25zaWRlcmluZyB0cnlpbmcgYSBoaWdoZXIg Y29uZmlndXJhdGlvbiBpbnN0YW5jZS48L3NwYW4+PC9kaXY+PHAgc3R5bGU9Im1hcmdpbjogMDsi Pjxicj48L3A+PGRpdiBzdHlsZT0icG9zaXRpb246cmVsYXRpdmU7em9vbToxIj48L2Rpdj48ZGl2 IGlkPSJkaXZOZXRlYXNlTWFpbENhcmQiPjwvZGl2PjxwIHN0eWxlPSJtYXJnaW46IDA7Ij48YnI+ PC9wPjxwcmU+PGJyPkF0IDIwMjMtMDctMjcgMTE6MzY6MjAsICJEYXZpZCBSb3dsZXkiICZsdDtk Z3Jvd2xleW1sQGdtYWlsLmNvbSZndDsgd3JvdGU6CiZndDtPbiBXZWQsIDI2IEp1bCAyMDIzIGF0 IDE5OjQ2LCBnemggJmx0O2d6aGNvZGVyQDEyNi5jb20mZ3Q7IHdyb3RlOgomZ3Q7Jmd0OyBRVUVS WSBQTEFOIChlbmFibGVfc2Vxc2Nhbj1vbikKJmd0OwomZ3Q7Jmd0OyBFeGVjdXRpb24gVGltZTog MTY3MTgzLjEzMyBtcwomZ3Q7CiZndDsmZ3Q7IFFVRVJZIFBMQU4gKGVuYWJsZV9zZXFzY2FuPW9m ZikKJmd0OwomZ3Q7Jmd0OyBFeGVjdXRpb24gVGltZTogMjIzMjAuMTUzIG1zCiZndDsKJmd0O2Vm ZmVjdGl2ZV9jYWNoZV9zaXplIGFuZCByYW5kb21fcGFnZV9jb3N0IGFyZSB0aGUgc2V0dGluZ3Mg eW91IHNob3VsZAomZ3Q7YmUgYWRqdXN0aW5nIHRvIGNvYXggdGhlIHBsYW5uZXIgaW50byB1c2lu ZyB0aGUgaW5kZXguCiZndDsKJmd0O0EgcnVsZSBvZiB0aHVtYiBmb3IgZWZmZWN0aXZlX2NhY2hl X3NpemUgd291bGQgYmUgdG8gc2V0IGl0IHRvIGFib3V0CiZndDs3NSUgb2YgUkFNLiBUaGVyZSBh cmUgY2VydGFpbmx5IGNhc2VzIHdoZXJlIGxvd2VyIHdvdWxkIG1ha2UgbW9yZQomZ3Q7c2Vuc2Us IGNlcnRhaW5seSwgNzUlIHdpbGwgbWFrZSBtb3JlIHNlbnNlIHRoYW4gdGhlIGRlZmF1bHQgNEdC IHZhbHVlCiZndDtpbiB0aGUgbWFqb3JpdHkgb2YgY2FzZXMuCiZndDsKJmd0O0ZvciByYW5kb21f cGFnZV9jb3N0LCB0aGUgZGVmYXVsdCBvZiA0LjAgaGFzIGJlZW4gdGhlIGRlZmF1bHQgc2luY2UK Jmd0O0hERHMgd2VyZSBjb21tb24uIFNTRHMgYXJlIGNvbW1vbiBub3cgYW5kLCBjb21wYXJhdGl2 ZWx5IHRvIHNlcXVlbnRpYWwKJmd0O0kvTywgdGhlaXIgcmFuZG9tIEkvTyBpcyBmYXN0ZXIgdGhh biB0aGF0IG9mIGFuIEhERCwgc28geW91IG1heSBnZXQKJmd0O2JldHRlciByZXN1bHRzIGJ5IGxv d2VyaW5nIHJhbmRvbV9wYWdlX2Nvc3QuCiZndDsKJmd0O0RhdmlkCjwvcHJlPjwvZGl2Pg== ------=_Part_77845_1909810054.1690445367328--