X-Original-To: pgsql-patches-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1525452A06 for ; Tue, 28 Jun 2005 09:54:25 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 19359-08 for ; Tue, 28 Jun 2005 12:54:16 +0000 (GMT) Received: from trolak.mydnsbox2.com (ns1.mydnsbox2.com [207.44.142.118]) by svr1.postgresql.org (Postfix) with ESMTP id CD25B528D5 for ; Tue, 28 Jun 2005 09:54:15 -0300 (ADT) Received: from [192.168.1.103] (cpe-024-211-165-134.nc.res.rr.com [24.211.165.134]) (authenticated (0 bits)) by trolak.mydnsbox2.com (8.11.6/8.11.6) with ESMTP id j5SC7c512569; Tue, 28 Jun 2005 07:07:38 -0500 Message-ID: <42C1485E.3080008@dunslane.net> Date: Tue, 28 Jun 2005 08:53:50 -0400 From: Andrew Dunstan User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.8) Gecko/20050513 Fedora/1.7.8-1.3.1 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Luke Lonergan Cc: Alvaro Herrera , Bruce Momjian , Alon Goldshuv , pgsql-patches@postgresql.org Subject: Re: COPY FROM performance improvements References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.025 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/546 X-Sequence-Number: 16278 Luke, Alon OK, I'm going to apply the patch to my copy and try to get my head around it. meanwhile: . we should not be describing things as "old" or "new". The person reading the code might have no knowledge of the history, and should not need to. . we should not have "slow" and "fast" either. We should have "text", "csv" and "binary". IOW, the patch comments look slightly like it is intended for after the fact application rather than incorporation into the main code. Are you looking at putting CSV mode into the fast code? Please let me know if you have questions about that. There are only a few days left to whip this into shape. cheers andrew Luke Lonergan wrote: >Andrew, > > > >>Something strange has happened. I suspect that you've inadvertantly used >>GNU indent or an unpatched BSD indent. pgindent needs a special patched >>BSD indent to work according to the PG standards - see the README >> >> > >OK - phew! I generated new symbols for pgindent and fixed a bug in the awk >scripting within (diff attached) and ran against the CVS tip copy.c and got >only minor changes in formatting that appear to be consistent with the rest >of the code. I pgindent'ed the COPY FROM performance modded code and it >looks good and tests good. > >Only formatting changes to the previous patch for copy.c attached. > >Patch to update pgindent with new symbols and fix a bug in an awk section >(extra \\ in front of a ')'). > >- Luke > > >