X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id E9D659FA4BB for ; Wed, 13 Sep 2006 12:57:25 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 49025-09 for ; Wed, 13 Sep 2006 12:57:20 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from bay0-omc2-s23.bay0.hotmail.com (bay0-omc2-s23.bay0.hotmail.com [65.54.246.159]) by postgresql.org (Postfix) with ESMTP id 6936A9FA48D for ; Wed, 13 Sep 2006 12:57:20 -0300 (ADT) Received: from hotmail.com ([64.4.38.45]) by bay0-omc2-s23.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 13 Sep 2006 08:57:19 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 13 Sep 2006 08:57:19 -0700 Message-ID: Received: from 64.4.38.200 by by116fd.bay116.hotmail.msn.com with HTTP; Wed, 13 Sep 2006 15:57:14 GMT X-Originating-IP: [66.160.12.211] X-Originating-Email: [bitsandbytes88@hotmail.com] X-Sender: bitsandbytes88@hotmail.com In-Reply-To: <21688.1158096472@sss.pgh.pa.us> From: "Mr. Dan" To: tgl@sss.pgh.pa.us Cc: pgsql-admin@postgresql.org Subject: Re: COPY FROM command v8.1.4 Date: Wed, 13 Sep 2006 11:57:14 -0400 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 13 Sep 2006 15:57:19.0106 (UTC) FILETIME=[4A9F8620:01C6D74D] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.498 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, MSGID_FROM_MTA_HEADER, SPF_PASS X-Spam-Level: * X-Archive-Number: 200609/108 X-Sequence-Number: 23022 >This is pretty confusing. You mean that groups of 25 adjacent rows were >missing in the output? Yes, isn't that interesting? It's always in a group of 25 rows. This is always random. Say 800,000 to 800,025 out of 12 million represents one random group of 25 rows. >What's the (24+1) supposed to convey? One time we thought we counted 24 rows. (in a row - yes adjacent) >groups aligned on 25-row boundaries in the whole output (ie, are there >an exact multiple of 25 rows before each dropped group)? Yes >How are you doing the copies, exactly? SQL COPY command, psql \copy, >something else? We've tried SQL COY and psql \copy and always get random results - 0,1, or 2 blocks of 25 rows missing. Is there a pre-compiled version of postgres we can try ? Where could I download that? We built postgres with GNU make 3.80, the documentation says 3.76 and higher is ok.