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 1rSy4G-00H5BE-A4 for pgsql-docs@arkaria.postgresql.org; Thu, 25 Jan 2024 11:38:48 +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 1rSy4F-00FwNH-Bf for pgsql-docs@arkaria.postgresql.org; Thu, 25 Jan 2024 11:38:47 +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 1rSrdt-00C98I-5b for pgsql-docs@lists.postgresql.org; Thu, 25 Jan 2024 04:47:09 +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 1rSrdp-003ack-Mq for pgsql-docs@lists.postgresql.org; Thu, 25 Jan 2024 04:47:08 +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=hKvWtqyyUqTK3CQGrDGxrkYlS/0xcpHXrEy/35Wd41U=; b=xzjytWJrm2lgBqk8VHNEqoQkG0 v0rm6o8kPepEfCvVUI4n1d01nonfbclE9Q5hhxe9E7TSjUSpH5CScUcGZ8B5QtHAnBqrGhOMqjYeV Zyh+rbcmB9/3TBqCBUZS4ow9FgIynSMNLObebnJ8+gaHM6SfAcJSPCTJzfpCwMqpWW1Uncsbk+qhe HrIjbyz4xQmqh2Hv4yloMYQO72eq96VJDczWsNDx/hQTQTnqUKC+4ManBpkrxBZGH9URbLew96gta Zy0dC2bWrtnnF8IL96lX1M+Z1evHniyT6PGeJuQ8M7NVCUlWTtt0vp12a1H4dA4DA+iFk76ISFSPw G7SnAlww==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rSrdo-009qFH-0q for pgsql-docs@lists.postgresql.org; Thu, 25 Jan 2024 04:47: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 1rSrdm-005MEG-DW for pgsql-docs@lists.postgresql.org; Thu, 25 Jan 2024 04:47:02 +0000 Content-Type: multipart/mixed; boundary="===============8032864893790476450==" MIME-Version: 1.0 Subject: It would be nice to clarify is there any point in select queries pipelining To: pgsql-docs@lists.postgresql.org From: PG Doc comments form Cc: evgeny.v.smirnov@gmail.com Reply-To: evgeny.v.smirnov@gmail.com, pgsql-docs@lists.postgresql.org Date: Thu, 25 Jan 2024 04:46:56 +0000 Message-ID: <170615801656.662.17755050278063339844@wrigleys.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 --===============8032864893790476450== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBkb2N1bWVudGF0aW9uIGNvbW1lbnQgaGFzIGJlZW4gbG9nZ2VkIG9uIHRo ZSB3ZWJzaXRlOgoKUGFnZTogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xNi9wcm90 b2NvbC1mbG93Lmh0bWwKRGVzY3JpcHRpb246CgpHcmVldGluZyENClBsZWFzZSBjb25zaWRlciB0 aGUgZm9sbG93aW5nIGV4Y2hhbmdlIHdpdGggYSBQRyBkYXRhYmFzZSAoS290bGluICsgUmVhY3Rv cisKcjJkYmMtcG9zdGdyZXNxbCk6DQpgYGANCiAgICAgMjk1ICAgIDEuMDYzMTY2ICAgIDEyNy4w LjAuMSAgIDUwNTkxICAgMTI3LjAuMC4xICAgMzI3OTcgICBQR1NRTCAgIDExMQo+USAtLS0+IEJF R0lOIElTT0xBVElPTiBMRVZFTCBSRVBFQVRBQkxFIFJFQUQsIFJFQUQgV1JJVEUNCiAgICAgMjk2 ICAgIDEuMDYzMjE5ICAgIDEyNy4wLjAuMSAgIDMyNzk3ICAgMTI3LjAuMC4xICAgNTA1OTEgICBU Q1AgNTYgCjMyNzk3IOKGkiA1MDU5MSBbQUNLXSBTZXE9MSBBY2s9NTYgV2luPTYzNzMgTGVuPTAg VFN2YWw9MzI2NjE3Nzg4MgpUU2Vjcj0zNzI4NjkwNzY3DQogICAgIDMwMSAgICAxLjA2OTkxMiAg ICAxMjcuMC4wLjEgICAzMjc5NyAgIDEyNy4wLjAuMSAgIDUwNTkxICAgUEdTUUwgICA3MyAKPEMv Wg0KICAgICAzMDIgICAgMS4wNjk5MzggICAgMTI3LjAuMC4xICAgNTA1OTEgICAxMjcuMC4wLjEg ICAzMjc5NyAgIFRDUCA1NiAKNTA1OTEg4oaSIDMyNzk3IFtBQ0tdIFNlcT01NiBBY2s9MTggV2lu PTYzNzAgTGVuPTAgVFN2YWw9MzcyODY5MDc3NApUU2Vjcj0zMjY2MTc3ODg5DQogICAgIDcxMiAg ICAxLjA5OTgyOSAgICAxMjcuMC4wLjEgICA1MDU5MSAgIDEyNy4wLjAuMSAgIDMyNzk3ICAgUEdT UUwgICA1NTEKPlEgLS0tLS0tPiBzZWxlY3QgKiBmcm9tIC4uLiAoIzIpDQogICAgIDcxMyAgICAx LjA5OTg1OCAgICAxMjcuMC4wLjEgICAzMjc5NyAgIDEyNy4wLjAuMSAgIDUwNTkxICAgVENQIDU2 IAozMjc5NyDihpIgNTA1OTEgW0FDS10gU2VxPTE4IEFjaz01NTEgV2luPTYzNjUgTGVuPTAgVFN2 YWw9MzI2NjE3NzkxOQpUU2Vjcj0zNzI4NjkwODA0DQogICAgIDcxNSAgICAxLjA5OTk4NSAgICAx MjcuMC4wLjEgICA1MDU5MSAgIDEyNy4wLjAuMSAgIDMyNzk3ICAgUEdTUUwgICA1NTEKPlEgLS0t LS0tPiBzZWxlY3QgKiBmcm9tIC4uLiAoIzQpDQogICAgIDcxNyAgICAxLjEwMDAwOSAgICAxMjcu MC4wLjEgICAzMjc5NyAgIDEyNy4wLjAuMSAgIDUwNTkxICAgVENQIDU2IAozMjc5NyDihpIgNTA1 OTEgW0FDS10gU2VxPTE4IEFjaz0xMDQ2IFdpbj02MzU4IExlbj0wIFRTdmFsPTMyNjYxNzc5MTkK VFNlY3I9MzcyODY5MDgwNA0KICAgICA3MTkgICAgMS4xMDAwODIgICAgMTI3LjAuMC4xICAgNTA1 OTEgICAxMjcuMC4wLjEgICAzMjc5NyAgIFBHU1FMICAgNTUxCj5RIC0tLS0tLT4gc2VsZWN0ICog ZnJvbSAuLi4gKCMxKQ0KICAgICA3MjAgICAgMS4xMDAxMDYgICAgMTI3LjAuMC4xICAgMzI3OTcg ICAxMjcuMC4wLjEgICA1MDU5MSAgIFRDUCA1NiAKMzI3OTcg4oaSIDUwNTkxIFtBQ0tdIFNlcT0x OCBBY2s9MTU0MSBXaW49NjM1MCBMZW49MCBUU3ZhbD0zMjY2MTc3OTE5ClRTZWNyPTM3Mjg2OTA4 MDQNCiAgICAgNzIyICAgIDEuMTAwMTY0ICAgIDEyNy4wLjAuMSAgIDUwNTkxICAgMTI3LjAuMC4x ICAgMzI3OTcgICBQR1NRTCAgIDU1MQo+USAtLS0tLS0+IHNlbGVjdCAqIGZyb20gLi4uICgjMykN CiAgICAgNzIzICAgIDEuMTAwMTkyICAgIDEyNy4wLjAuMSAgIDMyNzk3ICAgMTI3LjAuMC4xICAg NTA1OTEgICBUQ1AgNTYgCjMyNzk3IOKGkiA1MDU5MSBbQUNLXSBTZXE9MTggQWNrPTIwMzYgV2lu PTYzNDIgTGVuPTAgVFN2YWw9MzI2NjE3NzkxOQpUU2Vjcj0zNzI4NjkwODA0DQogICAgIDczNSAg ICAxLjExNDY5NSAgICAxMjcuMC4wLjEgICAzMjc5NyAgIDEyNy4wLjAuMSAgIDUwNTkxICAgUEdT UUwgICA0MjQKPFQvRC9DL1ogLS0tLS0tPiBSZXN1bHRzIGZvciAjMg0KICAgICA3MzcgICAgMS4x MTQ3NDEgICAgMTI3LjAuMC4xICAgNTA1OTEgICAxMjcuMC4wLjEgICAzMjc5NyAgIFRDUCA1NiAK NTA1OTEg4oaSIDMyNzk3IFtBQ0tdIFNlcT0yMDM2IEFjaz0zODYgV2luPTYzNjQgTGVuPTAgVFN2 YWw9MzcyODY5MDgxOApUU2Vjcj0zMjY2MTc3OTMzDQogICAgIDc3MyAgICAxLjEyMTczMiAgICAx MjcuMC4wLjEgICAzMjc5NyAgIDEyNy4wLjAuMSAgIDUwNTkxICAgUEdTUUwgICAxNDY4CiAgIDxU L0QvRC9EL0QvRC9EL0QvRC9EL0QvRC9EL0MvWiAtLS0tLS0+IFJlc3VsdHMgZm9yICM0DQogICAg IDc3NCAgICAxLjEyMTc1NyAgICAxMjcuMC4wLjEgICA1MDU5MSAgIDEyNy4wLjAuMSAgIDMyNzk3 ICAgVENQIDU2IAo1MDU5MSDihpIgMzI3OTcgW0FDS10gU2VxPTIwMzYgQWNrPTE3OTggV2luPTYz NDIgTGVuPTAgVFN2YWw9MzcyODY5MDgyNgpUU2Vjcj0zMjY2MTc3OTQxDQogICAgIDc4NSAgICAx LjEyNjc5MyAgICAxMjcuMC4wLjEgICAzMjc5NyAgIDEyNy4wLjAuMSAgIDUwNTkxICAgUEdTUUwg ICA1OTQKPFQvRC9EL0QvQy9aIC0tLS0tLT4gUmVzdWx0cyBmb3IgIzENCiAgICAgNzg2ICAgIDEu MTI2ODIwICAgIDEyNy4wLjAuMSAgIDUwNTkxICAgMTI3LjAuMC4xICAgMzI3OTcgICBUQ1AgNTYg CjUwNTkxIOKGkiAzMjc5NyBbQUNLXSBTZXE9MjAzNiBBY2s9MjMzNiBXaW49NjMzNCBMZW49MCBU U3ZhbD0zNzI4NjkwODMxClRTZWNyPTMyNjYxNzc5NDYNCiAgICAgODA1ICAgIDEuMTM1MTk3ICAg IDEyNy4wLjAuMSAgIDMyNzk3ICAgMTI3LjAuMC4xICAgNTA1OTEgICBQR1NRTCAgIDQ5Nwo8VC9E L0QvQy9aIC0tLS0tLT4gUmVzdWx0cyBmb3IgIzMNCiAgICAgODA2ICAgIDEuMTM1MjIyICAgIDEy Ny4wLjAuMSAgIDUwNTkxICAgMTI3LjAuMC4xICAgMzI3OTcgICBUQ1AgNTYgCjUwNTkxIOKGkiAz Mjc5NyBbQUNLXSBTZXE9MjAzNiBBY2s9Mjc3NyBXaW49NjMyNyBMZW49MCBUU3ZhbD0zNzI4Njkw ODM5ClRTZWNyPTMyNjYxNzc5NTQNCiAgICAgODQ3ICAgIDEuMTM4ODQ4ICAgIDEyNy4wLjAuMSAg IDUwNTkxICAgMTI3LjAuMC4xICAgMzI3OTcgICBQR1NRTCAgIDY4IAo+USAtLS0tLS0+IENPTU1J VA0KICAgICA4NDggICAgMS4xMzg4NzYgICAgMTI3LjAuMC4xICAgMzI3OTcgICAxMjcuMC4wLjEg ICA1MDU5MSAgIFRDUCA1NiAKMzI3OTcg4oaSIDUwNTkxIFtBQ0tdIFNlcT0yNzc3IEFjaz0yMDQ4 IFdpbj02MzQyIExlbj0wIFRTdmFsPTMyNjYxNzc5NTgKVFNlY3I9MzcyODY5MDg0Mw0KICAgICA4 NTMgICAgMS4xNDQ2MjQgICAgMTI3LjAuMC4xICAgMzI3OTcgICAxMjcuMC4wLjEgICA1MDU5MSAg IFBHU1FMICAgNzQgCjxDL1oNCmBgYA0KDQpUaGUgYXBwbGljYXRpb24gY29kZSBpcyB0aGUgZm9s bG93aW5nIChmb3IgdGhlIHNha2Ugb2YgY2xhcml0eSk6DQpgYGANCnZhbCB0cmFuc2FjdGlvbmFs T3BlcmF0b3IgPSBUcmFuc2FjdGlvbmFsT3BlcmF0b3IuY3JlYXRlKA0KICAgIHRyYW5zYWN0aW9u TWFuYWdlciwNCiAgICBEZWZhdWx0VHJhbnNhY3Rpb25EZWZpbml0aW9uKCkgLmFwcGx5IHsNCiAg ICAgICAgaXNvbGF0aW9uTGV2ZWwgPSBUcmFuc2FjdGlvbkRlZmluaXRpb24uSVNPTEFUSU9OX1JF UEVBVEFCTEVfUkVBRA0KICAgIH0NCikNCg0KdmFsIHVzZXJzID0gRmx1eC5kZWZlciB7DQogICAg Rmx1eC5jcmVhdGUgew0KICAgICAgICBpdC5uZXh0KDEpDQogICAgICAgIGl0Lm5leHQoMikNCiAg ICAgICAgaXQubmV4dCgzKQ0KICAgICAgICBpdC5uZXh0KDQpDQogICAgICAgIGl0LmNvbXBsZXRl KCkNCiAgICB9DQogICAgICAgIC5wYXJhbGxlbCg0KQ0KICAgICAgICAucnVuT24oU2NoZWR1bGVy cy5wYXJhbGxlbCgpKQ0KICAgICAgICAuZmxhdE1hcCB7DQogICAgICAgICAgICBkYXRhYmFzZUNs aWVudC5zcWwoDQogICAgICAgICAgICAgICAgIiIiDQogICAgICAgICAgICAgICAgICAgIHNlbGVj dCAqIGZyb20g4oCmDQogICAgICAgICAgICAgICAgIiIiLnRyaW1JbmRlbnQoKSkNCiAgICAgICAg ICAgICAgICAubWFwIHsgcm93LCBfIC0+IEVudGl0eUNvbnZlcnRlcigpLmNvbnZlcnQocm93KSB9 DQogICAgICAgICAgICAgICAgLmFsbCgpDQogICAgICAgICAgICAgICAgLnJlZHVjZShFbnRpdHlS ZWR1Y2VyKCkpDQogICAgICAgIH0NCn0uYGFzYCh0cmFuc2FjdGlvbmFsT3BlcmF0b3I6OnRyYW5z YWN0aW9uYWwpDQpgYGANCg0KSeKAmW0gYXdhcmUgdGhhdCBQb3N0Z3JlcyBkb2VzbuKAmXQgc3Vw cG9ydCBjdXJzb3IocG9ydGFsKSBtdWx0aXBsZXhpbmcgc28gaXRzCmltcG9zc2libGUgdG8gZmV0 Y2ggZGF0YSBmb3IgdHdvIHNlbGVjdHMgc2ltdWx0YW5lb3VzbHkgYnV0IHNob3VsZCBJIG1ha2UK dXNlIG9mIHNlbGVjdHMgcGlwZWxpbmluZyB3aGVuIEkgd2FudCB0byBtYWtlIHRoZSBtb3N0IG9m IHRoZSBEQj8gSSBtZWFuIHRvCnNheSBkb2VzIGEgc2luZ2xlIFBvc3RncmVzIGJhY2tlbmQgZW1w bG95cyBjb25jdXJyZW50IHByb2Nlc3NpbmcgYW5kIGl0cwpwb3NzaWJsZSBmb3IgYSBEQiB0byB0 cmFuc21pdCByZXN1bHRzIGZvciBhIHF1ZXJ5ICMyIChzZWUgdGhlIHRyYWZmaWMpIGFuZApjb25j dXJyZW50bHkgcGFyc2UvcmV3cml0ZS9wbGFuL29wdGltaXplIHRoZSBzdWJzZXF1ZW50IChwaXBl bGluZWQpIHF1ZXJpZXMKKGlzc3VlZCBmcm9tIHRoZSBzYW1lIHRyYW5zYWN0aW9uKS4gTmVpdGhl ciBjaGFwdGVyIDU1IG5vciA1MiBleHBhbmQgb24gaXQKKG9yIGl04oCZcyBoYXJkIHRvIHNwb3Qg YXQgbGVhc3QpLg0KDQpUaGFua3MhCg== --===============8032864893790476450==--