Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1jGfk8-0001Kc-4f for pgsql-hackers@arkaria.postgresql.org; Tue, 24 Mar 2020 09:21:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1jGfk6-0003uj-OA for pgsql-hackers@arkaria.postgresql.org; Tue, 24 Mar 2020 09:21:02 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1jGfk5-0003uc-Ja for pgsql-hackers@lists.postgresql.org; Tue, 24 Mar 2020 09:21:02 +0000 Received: from out3-smtp.messagingengine.com ([66.111.4.27]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jGfk2-0002Ct-L0 for pgsql-hackers@postgresql.org; Tue, 24 Mar 2020 09:21:00 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.nyi.internal (Postfix) with ESMTP id 2FCF45C026D; Tue, 24 Mar 2020 05:20:57 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute1.internal (MEProxy); Tue, 24 Mar 2020 05:20:57 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm2; bh=f2MxXLAlmXTwaWsjdgSL/ljKI0W5TM1FsOJSEW5oc iM=; b=0g9Jr84Tua7mcHkle19IhVR1KM2L8GrFG4KzfORCNbGI2fFCUrBksuNt0 /sRsQW0/zTwZ4a+Qbem69O1madtogT+xbgrkfrk5hGXGN2w1wq+tZtARTvZQxfSj 09j3KwIdlgsbc+O+kMdhBackYxccAtxc4oyRCPxjIQ0pcbZdlCKAWxW06B3QRIpJ j0GE8/kpHNFeHNgbCLLx1Nr2GYnkGZM94qnhy3mB46uN3p7nHnu5Keb8OlTPcmVH RTNcn3uS9zsif5uwdcyRNf48hQVK6xUULBp83XDObQGvDuzIlSOzpcfNIpD1bP07 UJsB+AP3uIUiCTEgiYYcO3/EjEdSQ== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedugedrudehtddgtdduucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepuffvfhfhohfkffgfgggjtgfgsehtjeertddtfeelnecuhfhrohhmpefrvght vghrucfgihhsvghnthhrrghuthcuoehpvghtvghrrdgvihhsvghnthhrrghuthesvdhnug hquhgrughrrghnthdrtghomheqnecuffhomhgrihhnpedvnhguqhhurggurhgrnhhtrdgt ohhmnecukfhppeelfedrvdegvddrvddufedrvdegudenucevlhhushhtvghrufhiiigvpe dtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehpvghtvghrrdgvihhsvghnthhrrghuthes vdhnughquhgrughrrghnthdrtghomh X-ME-Proxy: Received: from april.pezone.net (p5df2d5f1.dip0.t-ipconnect.de [93.242.213.241]) by mail.messagingengine.com (Postfix) with ESMTPA id CDF733280065; Tue, 24 Mar 2020 05:20:55 -0400 (EDT) Subject: Re: Unicode normalization SQL functions To: Daniel Verite References: <6d55838c-9353-486f-a508-77ee07d59667@manitou-mail.org> Cc: Andreas Karlsson , pgsql-hackers From: Peter Eisentraut Organization: 2ndQuadrant Message-ID: <620b155b-a89c-d8e0-3cbb-315c3ca538f4@2ndquadrant.com> Date: Tue, 24 Mar 2020 10:20:54 +0100 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: <6d55838c-9353-486f-a508-77ee07d59667@manitou-mail.org> Content-Type: text/plain; charset=iso-8859-15; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2020-03-23 17:26, Daniel Verite wrote: > Peter Eisentraut wrote: > >> What is that status of this patch set? I think we have nailed down the >> behavior, but there were some concerns about certain performance >> characteristics. Do people feel that those are required to be addressed >> in this cycle? > > Not finding any other issue with v3 or objections in the thread, > I've set the status to Ready For Committer in the CF. I have committed the 0001 patch. Now I have some concerns about the size of the new table in unicode_normprops_table.h, and the resulting binary size. At the very least, we should probably make that #ifndef FRONTEND or something like that so libpq isn't bloated by it unnecessarily. Perhaps there is a better format for that table? Any ideas? -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services