Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1b5Cnn-000472-Ty for pgsql-hackers@arkaria.postgresql.org; Tue, 24 May 2016 13:55:20 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1b5Cnn-0002db-Gk for pgsql-hackers@arkaria.postgresql.org; Tue, 24 May 2016 13:55:19 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1b5Cnm-0002dU-TH for pgsql-hackers@postgresql.org; Tue, 24 May 2016 13:55:19 +0000 Received: from mail-by2on0059.outbound.protection.outlook.com ([207.46.100.59] helo=na01-by2-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1b5Cnj-0002SQ-PT for pgsql-hackers@postgresql.org; Tue, 24 May 2016 13:55:17 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=BlueTreble.onmicrosoft.com; s=selector1-bluetreble-com; h=From:To:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=g0bCdwR6O0Xshpx62rBbrZTvmpRyvGW13U4sEppVafw=; b=UQ+m3gK8h8kK8/ekz26kuTcalCn8VHcrQiNiGCPuZ06ku0a/T/JRlV8NCD1sKLJu11UyzX5KdYShqVoeXqHZn/JnUjxom6aQmDwKqkQEph8+d2p1YhJG1i6tPRYd9DKDcy+f+nG7yeb5uT3HSjXjqC6VSitRNcnMtE3ZmfNU7Fs= Authentication-Results: lab.ntt.co.jp; dkim=none (message not signed) header.d=none;lab.ntt.co.jp; dmarc=none action=none header.from=BlueTreble.com; Received: from decina.attlocal.net (108.232.179.70) by CY1PR11MB0683.namprd11.prod.outlook.com (10.163.236.21) with Microsoft SMTP Server (TLS) id 15.1.501.7; Tue, 24 May 2016 13:55:13 +0000 Subject: Re: PATCH: Batch/pipelining support for libpq To: Craig Ringer , PostgreSQL Hackers References: CC: Michael Paquier , Manuel Kniep , "fujita.etsuro@lab.ntt.co.jp" From: Jim Nasby Message-ID: <5fa03f9a-de65-0190-d4da-77eff5dbe019@BlueTreble.com> Date: Tue, 24 May 2016 08:55:08 -0500 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:45.0) Gecko/20100101 Thunderbird/45.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset="windows-1252"; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [108.232.179.70] X-ClientProxiedBy: SN1PR08CA0015.namprd08.prod.outlook.com (10.161.221.25) To CY1PR11MB0683.namprd11.prod.outlook.com (10.163.236.21) X-MS-Office365-Filtering-Correlation-Id: 01def2b3-b071-4f44-3ef6-08d383db0794 X-Microsoft-Exchange-Diagnostics: 1;CY1PR11MB0683;2:dfNWgjYVLWm5H52EDKtfpFNxyidkUzsoHKseZ2IUb8GhTx0LqDUWgJxwRl19A/W99U+k8VHI4bFOfkinHirokhaC3y58XgJJpLhw88CxJfysoYcV04bYPZU6UncFd9dWYnE2XZlDXrlpWIv3GCFxI2B6Pmv1eNokKdSlWihNXhW7RuLqLGSoT0AJGnyJJXDz;3:ih9w58IW+E58BPRyunF1ZXHNK+0iE5Vo4kgVZAlxxX47LnXLrNHVbaE+FpgnsD8/u3albmPCzhuPWDO0WBwp0bO58s6Mkuil4fqkZ6EvDV4HZSIrALJKDgAhUStOQyJ5 X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:CY1PR11MB0683; X-Microsoft-Exchange-Diagnostics: 1;CY1PR11MB0683;25:KXtKAwD50lUM60/k2uVEhB9IA/Vj3mAar9InTQRPj+mCy4zx1y0GCd1hT5fLlinL+ug6frfz4O+1TfE+TdNLeMVgF2tR9RGe9LrNoMwlmb/CG75Rxf5AF1OK4p5ftTb8TCN8rRtLjmawaRTIP7b44ljTTyorhwTI9olVTb8HTcQY58axDt5QaT1lbpg3oDCfm0LfsgBtfB4PUxWFjHALICr6k1ov1FQFDU+0qs/eBb/z+iZnxNR6uGO3vqUe41ASQP18bNq3r6LtjMbuvqm6PExL0XxpefSsZzGZfIMZ0z9vUeKmVOtIVVgj1h7JtZCCCsv3ewforsY6jVqj4Tt5aE0LDx0XbcWrsrR/uTAGV5DfcWTkeGgoHFjPDNzKY8O5gTkOQ6sSz6igH8l4acXCuxlPEUhNMCtDAxWHzmKzRj/5HUb94BA7iJsFQufSWkzzfarT88C3d9VO7Rkw8gwI0sw9a795l19Hf5JbmXTRfxBwAXBw+oy+qLWNptrOoBK42AUwLAvnL7skmqq66x+kYCJzfwwDNXzoE2z1vtjFTAu+B7+pkREnrMSZM9ZXfCypN5MtR/kp//kcbDarSmAFCd4ueGjV+BWyBiwqT5YwWmAvBKkDKybq4RpXSFtBD5iWf6/o+KOBnSqecRFB4aPCklThubTzhTg7k/Yl3YoMzIiRmPIs15d4CzFD5nt6vch6zOmP32zgm02OFSSEzucQz6BGNsE478pxfaA8T9grEY3m6/CcyFpZrsDul6DUD+IAXOGZgKlBRunHnwCPUtdbD51UJsnlE6AeZyq1bYxZzaXicb3q0p/nKL2kX+Ozi0CO X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:; X-Exchange-Antispam-Report-CFA-Test: BCL:0;PCL:0;RULEID:(6040130)(601004)(2401047)(5005006)(8121501046)(10201501046)(3002001)(6041072)(6042046)(6043046);SRVR:CY1PR11MB0683;BCL:0;PCL:0;RULEID:;SRVR:CY1PR11MB0683; X-Microsoft-Exchange-Diagnostics: 1;CY1PR11MB0683;4:SS+mgY9FhhozvXbChT9yrYbbnf2iYehW3msEEgRZF2BEQys2AeWOpND98OW3Ey6C/FHPgVkhwUE5ChjLBeEcUGfafoIPcilVQwEWpoTqc7fzYh4bdFT5aHsN8szRkK2gRSC5C2ji+sHqubIAfhxVq71jL9WWeXvuaG6a44egn+pN2pQeAls5RQjtKsIoSwbKVcpO2Ly4Ghju9S1tjS2m8cvdV23YhQ0uA/5HcbY9/coOwPhknqNh+TJCyO9QhyI3dmX8kUwREPUypd1WIz27Lo4zJj7wJrlzcuPO8ZLxDCyvoNSjS9ksm5xdXskxqY4CHrWAJLJvbHoast2Ot0kSpbjdIr70dyickqfMhhjg+pu0PIMMpWNeukYwP7wz3wx5DKwkWm1zN1YHo48DS4ExtkHQ9bc6iqefL/KzTNrHUsjg8zgI5tZQN8h05/C9aSN3 X-Forefront-PRVS: 09525C61DB X-Forefront-Antispam-Report: SFV:NSPM;SFS:(10009020)(4630300001)(6009001)(24454002)(377454003)(50466002)(54356999)(53416004)(42186005)(86362001)(230700001)(76176999)(19580395003)(50986999)(36756003)(2950100001)(83506001)(5008740100001)(4326007)(6116002)(4001350100001)(5001770100001)(3846002)(586003)(189998001)(77096005)(2906002)(92566002)(33646002)(66066001)(8676002)(81166006)(23746002)(65956001)(65806001)(47776003)(31686004)(16601075003)(5004730100002)(31696002)(65826006)(85282002);DIR:OUT;SFP:1101;SCL:1;SRVR:CY1PR11MB0683;H:decina.attlocal.net;FPR:;SPF:None;MLV:sfv;LANG:en; X-Microsoft-Exchange-Diagnostics: =?Windows-1252?Q?1;CY1PR11MB0683;23:NTnUVsgE+8Udt6TXm1ANBymJ1yGyCYfJTDHTl?= =?Windows-1252?Q?pb+mzpMHLovr2YOimi2DQOeodgaPtPFvP7mi4MXi6OlIEMYTHt79DKjz?= =?Windows-1252?Q?oIYACgp+3YrFal9gq4IiONZsw1TcZkQG2AFfaZpDWQDLTQmCI2qRL8pd?= =?Windows-1252?Q?5Ugz0updJ7FJiAOHuXcO0XOQKELllmFZhaYSt+FYefKPUv+SL976cYOo?= =?Windows-1252?Q?y95qOMTwT7K8GWxv53YGCCYJBw2ToYK0DtPYv/5a/ngZBR4Ix7CC4rfb?= =?Windows-1252?Q?C/66AJVCx5lDvP7i78Ct6JLnv804EEUdlu3WKDh8NZEctxMBaxjyYBzp?= =?Windows-1252?Q?c+yztFLs5TNlhmR4FSxhp8EMDLSH/zwiQwXNVyIzyb7O6PX8PFeBvges?= =?Windows-1252?Q?x1XJZUKYctbjolDrikZVtX1rY9MRd2U9mp50zY49D5ae7ysRzeUdh1h3?= =?Windows-1252?Q?f1E6MhE3rc0f6+LiiADDaraLA5Da5P/rMBieiBD5PfjXs2k+QQS0o48r?= =?Windows-1252?Q?cs8VkRKVhhhqqhRuI88MtDs4b8IFV5jIQ/EcavcBMNIhaAhaFu4+mDnH?= =?Windows-1252?Q?QRJDOWFPG6rjP1bKHcLdXfSRBVCjp9yiAMQPyIRXcUEe2fW/iKNDKmo7?= =?Windows-1252?Q?W9bWuFKpG2pfR0bz5TKGv2NRQpGeked35te8MNLgaI3+oRnNVTlS5Mvt?= =?Windows-1252?Q?HPFFICi/beiGYBRgrea7IkesE+Tt+9Qcp5QMPxQBOqOqBmHvl1TvRAuo?= =?Windows-1252?Q?NzIY64Gfu8xQqUJCapOvuZVIuBkWwVsK2r7sjKEHzsgAEG9hSV8eI/aw?= =?Windows-1252?Q?TPOZISX0YkCJz2TAXQSmIdDkPtqbBfEufOfL2BZHA8dBKlVAJ5i/esmJ?= =?Windows-1252?Q?HsiBeOaUC2qkhNaRF412pRZXt+nAB7Gy8abp8Psk1v2k62cp6e/CAcjf?= =?Windows-1252?Q?+lz64AzYTlQqYM1cG46/sfpC3qOWUpP36sZPZ3UuAUFsJTHia+1HEg6G?= =?Windows-1252?Q?Hdk/Tb+hV2euLVzNm3Tz3JWq2sXhJ9rIL3jvfzWBsHnS04ca2KyinXv8?= =?Windows-1252?Q?LTzL1HR690CyW7xLYx0+BbflhNrYna5uCB7dN62w6CuW4bUmJ7YdNK1B?= =?Windows-1252?Q?rveAsRyhm2olrsNudBwdw5Niw1AG32H4XC2jF4027bgi8ig/2fv6WHmn?= =?Windows-1252?Q?JjA08YLDQ=3D=3D?= X-Microsoft-Exchange-Diagnostics: 1;CY1PR11MB0683;5:FB8COciQu+FzejHwg/vXGx7gh5EnC1fifiFSVdYgMPZlzcPZ1JalmVJ3k7kFKN7LkGmh5jR7p19rU0TF8Wxwdm8zI4ocBR2uTs/yEFYQz5BEItDQKv4eI7HnjK/DH2kvCxHAgdfZAdl7J3NtL7LXtg==;24:YsT6UcbU0qFqXuH5hMq/sD+GGecx9mw9f0K95iqnqEKzuWH7jtyxgYcL+2aBDo3q2VhoFsEPxJwhD6IZ66N+orNV8qdpeoWpYRAiwd79PGA=;7:2s6vdA+9B1LqeXIZwr68ObhDYTV+0vLdhwKY2qTQcswcV1MTFJN2zFcdj+TUWDVinLElPFRbLbT3M407f0StBkt45Sad0x28Ki6z4qO1lJeHWknCRdIaDN7Z28WjgbgEjggvIty8zeHbdlTGGDC32vfdw2Ny3lyGvz6jF7Qlc1hqnl/ETPpM9BPNTlaciUp/ SpamDiagnosticOutput: 1:23 SpamDiagnosticMetadata: NSPM X-OriginatorOrg: bluetreble.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 24 May 2016 13:55:13.2916 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-Transport-CrossTenantHeadersStamped: CY1PR11MB0683 X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 5/23/16 4:19 AM, Craig Ringer wrote: > + Batching less useful when information from one operation is required by the SB "Batching is less useful". -- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL Data in Trouble? Get it in Treble! http://BlueTreble.com 855-TREBLE2 (855-873-2532) mobile: 512-569-9461 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers