Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fgYXA-00008a-3X for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Jul 2018 16:45:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fgYX8-0006fs-AE for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Jul 2018 16:45:34 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fgYX8-0006fh-3G; Fri, 20 Jul 2018 16:45:34 +0000 Received: from new2-smtp.messagingengine.com ([66.111.4.224]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fgYWm-000211-Vh; Fri, 20 Jul 2018 16:45:33 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailnew.nyi.internal (Postfix) with ESMTP id BA63F257B; Fri, 20 Jul 2018 12:45:11 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute5.internal (MEProxy); Fri, 20 Jul 2018 12:45:11 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h= cc:content-type:date:from:in-reply-to:message-id:mime-version :references:subject:to:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; bh=Cc3GFr/iuG+t9ov7ypgWcXqTFLuO0gFuc3LWNeMmAd8=; b=J3khfK4A clXrA9TqXIMQjCQISivfT1Ts8IS8J6KnlyabX2ZcYYcmvFSbY3dRqQngZKpd1Bum AmSzU15RHPrju+EKWn7zCrbUgdAnLUepkp19lWvtZd8vyad8kstbphLI14pK+knP QTekOB6Qs1aq6Ox6Q8XEEVV33si8PSfynzvKIGEi0rNxyyGmoS2tiqEB7Jvjp6kA 2lAO49ktcpYB/q7I0iFCOaI+i/NwQ2BdJxo59i3RyT43wCGrCBGKFMZsO8jt/Slt U48XpjaAyN36+pJnx/4SAa7Bi/j9JJa7qi4Hob2dFlSPetkmWNNbt9e90ScLZG85 iq9VmhK/hrqYww== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-sender :x-me-sender:x-sasl-enc; s=fm3; bh=Cc3GFr/iuG+t9ov7ypgWcXqTFLuO0 gFuc3LWNeMmAd8=; b=MeQCpXK8FJtm+MiPC2950j8LLHtCZcYwwHEgGPgunc7Yt REKx6Qi39ZKWjLBUyIsiMh5CYZY3deqorDe5uCbfjgv/0zSh01xnJsJuu4TJldsV y/UbdDjIEVKweRw1Az1yvxuBNmvzdqKmqvuxl5NZ7u/VP9XPFDKFIrcwiVCeBDev ILFlJCiLzZPbUXFyvBhr793m2WM0oPM0vJTYaONvakAjGkVp85/GCcd8aT9mq5Qs nHnbGHE5uHfyoHB9kCWImvrkAMHpXM/bTdNelfW5us61J2p+YiefO5TOWTBD78TV RTZY56wvos7lK4Y06CaEBNjalCMBdHJq4AnB6Utuw== X-ME-Proxy: X-ME-Sender: Received: from intern.anarazel.de (c-75-69-87-158.hsd1.vt.comcast.net [75.69.87.158]) by mail.messagingengine.com (Postfix) with ESMTPA id 5A26AE4519; Fri, 20 Jul 2018 12:45:11 -0400 (EDT) Date: Fri, 20 Jul 2018 09:45:10 -0700 From: Andres Freund To: Robert Haas Cc: Alex Tokarev , "pgsql-hackers@postgresql.org" , pgsql-performance@postgresql.org Subject: Re: Faster str to int conversion (was Table with large number of int columns, very slow COPY FROM) Message-ID: <20180720164510.dvexjhtutylozmhj@alap3.anarazel.de> References: <20171208181734.db7gk22mtq7i44ax@alap3.anarazel.de> <20171208214437.qgn6zdltyq5hmjpk@alap3.anarazel.de> <20180707200158.wpqkd7rjr4jxq5g7@alap3.anarazel.de> <20180719203212.qso3vgljwns75oho@alap3.anarazel.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi, On 2018-07-20 08:27:34 -0400, Robert Haas wrote: > On Thu, Jul 19, 2018 at 4:32 PM, Andres Freund wrote: > >> 1. Why the error message changes? If there's a good reason, it should > >> be done as a separate commit, or at least well-documented in the > >> commit message. > > > > Because there's a lot of "invalid input syntax for type %s: \"%s\"", > > error messages, and we shouldn't force translators to have separate > > version that inlines the first %s. But you're right, it'd be worthwhile > > to point that out in the commit message. > > It just seems weird that they're bundled together in one commit like this. I'll push it separately. > Nothing else from me... Thanks for looking! Greetings, Andres Freund