Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q66g9-0007O9-RE for pgsql-general@arkaria.postgresql.org; Mon, 05 Jun 2023 09:39:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q66g8-0003pM-FJ for pgsql-general@arkaria.postgresql.org; Mon, 05 Jun 2023 09:39:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q66g7-0003mE-JT for pgsql-general@lists.postgresql.org; Mon, 05 Jun 2023 09:39:08 +0000 Received: from m1524.mail.126.com ([220.181.15.24]) by magus.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1q66g1-000LjL-Ic for pgsql-general@lists.postgresql.org; Mon, 05 Jun 2023 09:39:05 +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=nKmTfT6s1Ve2bdV92cZNd5jX6V9hpwIfQk3Skuz+dfw=; b=j IO7XzcXWHCOZT9Q8kMbDPRMmPLgDDdE2vLjNCRatRiZNN1CCxliDTKaPeT7jRStB YtR08a89EB56/fJaBaFgbugHBasm8jpGo8iac5w5PZsV5uo8GTPxVWcNbJfb+2iC IOrqwv7KiPL9LIVQIiO3+nEyAmyCK+0G4X4hLF1ha4= Received: from gzhcoder$126.com ( [211.144.19.63] ) by ajax-webmail-wmsvr24 (Coremail) ; Mon, 5 Jun 2023 17:38:55 +0800 (CST) X-Originating-IP: [211.144.19.63] Date: Mon, 5 Jun 2023 17:38:55 +0800 (CST) From: gzh To: "David Rowley" Cc: pgsql-general@lists.postgresql.org Subject: Re:Re: Is there any good optimization solution to improve the query efficiency? 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: <31b30205.4e00.1888a5803f1.Coremail.gzhcoder@126.com> X-NTES-SC: AL_QuyTB/WeuEEo4yKbY+kXk04Whec7WsOxvPsh2Y9ROJs0kSnp3zgtWFpJM0Pr6OK/Lx2wlT2+VChCxOJaV65/bYdqiACsyl6Dk4gMS+9/44cJ Content-Type: multipart/alternative; boundary="----=_Part_114382_18139029.1685957935239" MIME-Version: 1.0 Message-ID: <1a6cd283.79df.1888aec8088.Coremail.gzhcoder@126.com> X-Coremail-Locale: zh_CN X-CM-TRANSID: GMqowACnvs4vrX1kmLcoAA--.11971W X-CM-SenderInfo: 5j2ku0xghuqiyswou0bp/1tbiuB+FWWJVm3iabgACsZ X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_114382_18139029.1685957935239 Content-Type: text/plain; charset=GBK Content-Transfer-Encoding: base64 SGksIERhdmlkCgoKCgo+VGhlIGFib3ZlIGpvaW4ncyBzZWxlY3Rpdml0eSBlc3RpbWF0aW9uIHNl ZW1zIHRvIGJlIGNhdXNpbmcgYW4gdXBwZXIKCj5qb2luIHRvIHJlc29ydCB0byBwZXJmb3JtaW5n IGEgTmVzdGVkIExvb3Agam9pbiBiZWNhdXNlIHRoZSBwbGFubmVyCgo+dGhpbmtzIHRoZSBqb2lu IHdpbGwgb25seSBwcm9kdWNlIDEgcm93LgoKPgoKPlVuZm9ydHVuYXRlbHksIGV4dGVuZGVkIHN0 YXRpc3RpY3Mgb25seSBoZWxwIGZvciBiYXNlIHJlbGF0aW9uCgo+ZXN0aW1hdGlvbnMgYW5kIGRv IG5vdGhpbmcgZm9yIGpvaW4gZXN0aW1hdGlvbnMsIHNvIHlvdXIgYmVzdCBiZXQKCj5taWdodCBi ZSB0byBqdXN0OgoKPgoKPlNFVCBlbmFibGVfbmVzdGxvb3AgVE8gb2ZmOwoKPgoKPmZvciB0aGlz IHF1ZXJ5LgoKQWZ0ZXIgbWFraW5nIHRoZSBhZGp1c3RtZW50cyBhcyB5b3Ugc3VnZ2VzdGVkLCAK CnRoZSBTUUwgc3RhdGVtZW50IHRoYXQgcHJldmlvdXNseSB0b29rIDE2IG1pbnV0ZXMgdG8gcXVl cnkgcmVzdWx0cyBjYW4gbm93IGJlIHF1ZXJpZWQgaW4gbGVzcyB0aGFuIDEwIHNlY29uZHMuIAoK CgoKVGhhbmsgeW91IHZlcnkgbXVjaCBmb3IgdGFraW5nIHRoZSB0aW1lIHRvIHJlcGx5IHRvIG15 IHF1ZXN0aW9uIGFuZCBwcm92aWRpbmcgYSBzb2x1dGlvbiB0aGF0IHNvbHZlZCBteSBpc3N1ZS4g CgpZb3VyIGV4cGVydGlzZSBhbmQgd2lsbGluZ25lc3MgdG8gaGVscCBhcmUgZ3JlYXRseSBhcHBy ZWNpYXRlZCwgYW5kIEkgbGVhcm5lZCBhIGxvdCBmcm9tIHlvdXIgYW5zd2VyLiAKClRoYW5rcyBh Z2FpbiEKCgoKCgoKCgoKCgoKCgoKCgpBdCAyMDIzLTA2LTA1IDE2OjIxOjE5LCAiRGF2aWQgUm93 bGV5IiA8ZGdyb3dsZXltbEBnbWFpbC5jb20+IHdyb3RlOgo+T24gTW9uLCA1IEp1biAyMDIzIGF0 IDE4OjU2LCBnemggPGd6aGNvZGVyQDEyNi5jb20+IHdyb3RlOgo+PiBJJ20gcnVubmluZyBpbnRv IHNvbWUgcGVyZm9ybWFuY2UgaXNzdWVzIHdpdGggbXkgU1FMIHF1ZXJ5Lgo+PiBUaGUgZm9sbG93 aW5nIFNRTCBxdWVyeSBpcyB0YWtpbmcgYSBsb25nIHRpbWUgdG8gZXhlY3V0ZS4KPgo+PiAgICAg ICAgIC0+ICBIYXNoIEpvaW4gIChjb3N0PTI1MzM4OC40NC4uMzk0MTEyLjA3IHJvd3M9MSB3aWR0 aD01NikgKGFjdHVhbCB0aW1lPTExOTcuNDg0Li4yOTU0LjA4NCByb3dzPTMzMDExMSBsb29wcz0x KQo+PiAgICAgICAgICAgICAgIEhhc2ggQ29uZDogKChUX0NVU1QuUlNOTyA9IFRfQ1VTVF8xLlJT Tk8pIEFORCAoKFRfQ1VTVC5LTk8pOjp0ZXh0ID0gKFRfQ1VTVF8xLktOTyk6OnRleHQpIEFORCAo VF9DVVNULmdzdHNlcSA9IChtaW4oVF9DVVNUXzEuZ3N0c2VxKSkpKQo+PiAgICAgICAgICAgICAg IC0+ICBTZXEgU2NhbiBvbiBUQkxfQ1VTVCBUX0NVU1QgIChjb3N0PTAuMDAuLjc5NDMxLjE1IHJv d3M9MjAwMDMxNSB3aWR0aD02MSkgKGFjdHVhbCB0aW1lPTAuMDE1Li41NjEuMDA1IHJvd3M9MjAw MDc1MiBsb29wcz0xKQo+PiAgICAgICAgICAgICAgIC0+ICBIYXNoICAoY29zdD0yNDYyMzAuOTAu LjI0NjIzMC45MCByb3dzPTI2MjQ4OCB3aWR0aD01MCkgKGFjdHVhbCB0aW1lPTExOTcuMDI1Li4x MjA5Ljk1NyByb3dzPTMzMDExMSBsb29wcz0xKQo+Cj5UaGUgYWJvdmUgam9pbidzIHNlbGVjdGl2 aXR5IGVzdGltYXRpb24gc2VlbXMgdG8gYmUgY2F1c2luZyBhbiB1cHBlcgo+am9pbiB0byByZXNv cnQgdG8gcGVyZm9ybWluZyBhIE5lc3RlZCBMb29wIGpvaW4gYmVjYXVzZSB0aGUgcGxhbm5lcgo+ dGhpbmtzIHRoZSBqb2luIHdpbGwgb25seSBwcm9kdWNlIDEgcm93Lgo+Cj5VbmZvcnR1bmF0ZWx5 LCBleHRlbmRlZCBzdGF0aXN0aWNzIG9ubHkgaGVscCBmb3IgYmFzZSByZWxhdGlvbgo+ZXN0aW1h dGlvbnMgYW5kIGRvIG5vdGhpbmcgZm9yIGpvaW4gZXN0aW1hdGlvbnMsIHNvIHlvdXIgYmVzdCBi ZXQKPm1pZ2h0IGJlIHRvIGp1c3Q6Cj4KPlNFVCBlbmFibGVfbmVzdGxvb3AgVE8gb2ZmOwo+Cj5m b3IgdGhpcyBxdWVyeS4KPgo+RGF2aWQK ------=_Part_114382_18139029.1685957935239 Content-Type: text/html; charset=GBK Content-Transfer-Encoding: base64 PGRpdiBzdHlsZT0ibGluZS1oZWlnaHQ6MS43O2NvbG9yOiMwMDAwMDA7Zm9udC1zaXplOjE0cHg7 Zm9udC1mYW1pbHk6QXJpYWwiPjxwIHN0eWxlPSJtYXJnaW46IDA7Ij5IaSwgRGF2aWQ8L3A+PHAg c3R5bGU9Im1hcmdpbjogMDsiPjxicj48L3A+PHAgc3R5bGU9Im1hcmdpbjogMDsiPiZndDtUaGUg YWJvdmUgam9pbidzIHNlbGVjdGl2aXR5IGVzdGltYXRpb24gc2VlbXMgdG8gYmUgY2F1c2luZyBh biB1cHBlcjwvcD48cCBzdHlsZT0ibWFyZ2luOiAwOyI+Jmd0O2pvaW4gdG8gcmVzb3J0IHRvIHBl cmZvcm1pbmcgYSBOZXN0ZWQgTG9vcCBqb2luIGJlY2F1c2UgdGhlIHBsYW5uZXI8L3A+PHAgc3R5 bGU9Im1hcmdpbjogMDsiPiZndDt0aGlua3MgdGhlIGpvaW4gd2lsbCBvbmx5IHByb2R1Y2UgMSBy b3cuPC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7Ij4mZ3Q7PC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7 Ij4mZ3Q7VW5mb3J0dW5hdGVseSwgZXh0ZW5kZWQgc3RhdGlzdGljcyBvbmx5IGhlbHAgZm9yIGJh c2UgcmVsYXRpb248L3A+PHAgc3R5bGU9Im1hcmdpbjogMDsiPiZndDtlc3RpbWF0aW9ucyBhbmQg ZG8gbm90aGluZyBmb3Igam9pbiBlc3RpbWF0aW9ucywgc28geW91ciBiZXN0IGJldDwvcD48cCBz dHlsZT0ibWFyZ2luOiAwOyI+Jmd0O21pZ2h0IGJlIHRvIGp1c3Q6PC9wPjxwIHN0eWxlPSJtYXJn aW46IDA7Ij4mZ3Q7PC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7Ij4mZ3Q7U0VUIGVuYWJsZV9uZXN0 bG9vcCBUTyBvZmY7PC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7Ij4mZ3Q7PC9wPjxwIHN0eWxlPSJt YXJnaW46IDA7Ij4mZ3Q7Zm9yIHRoaXMgcXVlcnkuPC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7Ij5B ZnRlciBtYWtpbmcgdGhlIGFkanVzdG1lbnRzIGFzIHlvdSBzdWdnZXN0ZWQsJm5ic3A7PC9wPjxw IHN0eWxlPSJtYXJnaW46IDA7Ij50aGUgU1FMIHN0YXRlbWVudCB0aGF0IHByZXZpb3VzbHkgdG9v ayAxNiBtaW51dGVzIHRvIHF1ZXJ5IHJlc3VsdHMgY2FuIG5vdyBiZSBxdWVyaWVkIGluIGxlc3Mg dGhhbiAxMCBzZWNvbmRzLiZuYnNwOzwvcD48cCBzdHlsZT0ibWFyZ2luOiAwOyI+PGJyPjwvcD48 cCBzdHlsZT0ibWFyZ2luOiAwOyI+VGhhbmsgeW91IHZlcnkgbXVjaCBmb3IgdGFraW5nIHRoZSB0 aW1lIHRvIHJlcGx5IHRvIG15IHF1ZXN0aW9uIGFuZCBwcm92aWRpbmcgYSBzb2x1dGlvbiB0aGF0 IHNvbHZlZCBteSBpc3N1ZS4mbmJzcDs8L3A+PHAgc3R5bGU9Im1hcmdpbjogMDsiPllvdXIgZXhw ZXJ0aXNlIGFuZCB3aWxsaW5nbmVzcyB0byBoZWxwIGFyZSBncmVhdGx5IGFwcHJlY2lhdGVkLCBh bmQgSSBsZWFybmVkIGEgbG90IGZyb20geW91ciBhbnN3ZXIuJm5ic3A7PC9wPjxwIHN0eWxlPSJt YXJnaW46IDA7Ij5UaGFua3MgYWdhaW4hPC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7Ij48YnI+PC9w PjxwIHN0eWxlPSJtYXJnaW46IDA7Ij48YnI+PC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7Ij48YnI+ PC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7Ij48YnI+PC9wPjxkaXYgc3R5bGU9InBvc2l0aW9uOnJl bGF0aXZlO3pvb206MSI+PC9kaXY+PGRpdiBpZD0iZGl2TmV0ZWFzZU1haWxDYXJkIj48L2Rpdj48 cCBzdHlsZT0ibWFyZ2luOiAwOyI+PGJyPjwvcD48cHJlPjxicj5BdCAyMDIzLTA2LTA1IDE2OjIx OjE5LCAiRGF2aWQgUm93bGV5IiAmbHQ7ZGdyb3dsZXltbEBnbWFpbC5jb20mZ3Q7IHdyb3RlOgom Z3Q7T24gTW9uLCA1IEp1biAyMDIzIGF0IDE4OjU2LCBnemggJmx0O2d6aGNvZGVyQDEyNi5jb20m Z3Q7IHdyb3RlOgomZ3Q7Jmd0OyBJJ20gcnVubmluZyBpbnRvIHNvbWUgcGVyZm9ybWFuY2UgaXNz dWVzIHdpdGggbXkgU1FMIHF1ZXJ5LgomZ3Q7Jmd0OyBUaGUgZm9sbG93aW5nIFNRTCBxdWVyeSBp cyB0YWtpbmcgYSBsb25nIHRpbWUgdG8gZXhlY3V0ZS4KJmd0OwomZ3Q7Jmd0OyAgICAgICAgIC0m Z3Q7ICBIYXNoIEpvaW4gIChjb3N0PTI1MzM4OC40NC4uMzk0MTEyLjA3IHJvd3M9MSB3aWR0aD01 NikgKGFjdHVhbCB0aW1lPTExOTcuNDg0Li4yOTU0LjA4NCByb3dzPTMzMDExMSBsb29wcz0xKQom Z3Q7Jmd0OyAgICAgICAgICAgICAgIEhhc2ggQ29uZDogKChUX0NVU1QuUlNOTyA9IFRfQ1VTVF8x LlJTTk8pIEFORCAoKFRfQ1VTVC5LTk8pOjp0ZXh0ID0gKFRfQ1VTVF8xLktOTyk6OnRleHQpIEFO RCAoVF9DVVNULmdzdHNlcSA9IChtaW4oVF9DVVNUXzEuZ3N0c2VxKSkpKQomZ3Q7Jmd0OyAgICAg ICAgICAgICAgIC0mZ3Q7ICBTZXEgU2NhbiBvbiBUQkxfQ1VTVCBUX0NVU1QgIChjb3N0PTAuMDAu Ljc5NDMxLjE1IHJvd3M9MjAwMDMxNSB3aWR0aD02MSkgKGFjdHVhbCB0aW1lPTAuMDE1Li41NjEu MDA1IHJvd3M9MjAwMDc1MiBsb29wcz0xKQomZ3Q7Jmd0OyAgICAgICAgICAgICAgIC0mZ3Q7ICBI YXNoICAoY29zdD0yNDYyMzAuOTAuLjI0NjIzMC45MCByb3dzPTI2MjQ4OCB3aWR0aD01MCkgKGFj dHVhbCB0aW1lPTExOTcuMDI1Li4xMjA5Ljk1NyByb3dzPTMzMDExMSBsb29wcz0xKQomZ3Q7CiZn dDtUaGUgYWJvdmUgam9pbidzIHNlbGVjdGl2aXR5IGVzdGltYXRpb24gc2VlbXMgdG8gYmUgY2F1 c2luZyBhbiB1cHBlcgomZ3Q7am9pbiB0byByZXNvcnQgdG8gcGVyZm9ybWluZyBhIE5lc3RlZCBM b29wIGpvaW4gYmVjYXVzZSB0aGUgcGxhbm5lcgomZ3Q7dGhpbmtzIHRoZSBqb2luIHdpbGwgb25s eSBwcm9kdWNlIDEgcm93LgomZ3Q7CiZndDtVbmZvcnR1bmF0ZWx5LCBleHRlbmRlZCBzdGF0aXN0 aWNzIG9ubHkgaGVscCBmb3IgYmFzZSByZWxhdGlvbgomZ3Q7ZXN0aW1hdGlvbnMgYW5kIGRvIG5v dGhpbmcgZm9yIGpvaW4gZXN0aW1hdGlvbnMsIHNvIHlvdXIgYmVzdCBiZXQKJmd0O21pZ2h0IGJl IHRvIGp1c3Q6CiZndDsKJmd0O1NFVCBlbmFibGVfbmVzdGxvb3AgVE8gb2ZmOwomZ3Q7CiZndDtm b3IgdGhpcyBxdWVyeS4KJmd0OwomZ3Q7RGF2aWQKPC9wcmU+PC9kaXY+ ------=_Part_114382_18139029.1685957935239--