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 861EB9FA2A1 for ; Tue, 12 Sep 2006 18:29:17 -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 83629-03 for ; Tue, 12 Sep 2006 18:29:10 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id BEC9D9FA236 for ; Tue, 12 Sep 2006 18:29:09 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k8CLRqT3021689; Tue, 12 Sep 2006 17:27:52 -0400 (EDT) To: "Mr. Dan" cc: pgsql-admin@postgresql.org Subject: Re: COPY FROM command v8.1.4 In-reply-to: References: Comments: In-reply-to "Mr. Dan" message dated "Tue, 12 Sep 2006 13:38:19 -0400" Date: Tue, 12 Sep 2006 17:27:52 -0400 Message-ID: <21688.1158096472@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.11 tagged_above=0 required=5 tests=AWL, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200609/106 X-Sequence-Number: 23020 "Mr. Dan" writes: > Looking back and comparing the data, we realized that its always missing > rows in 25 (24+1) rows sequences or we're calling it a block. So, there were > 2 blocks of 25 missing in the 2nd attempt and 4 blocks of 25 missing in the > third. This is pretty confusing. You mean that groups of 25 adjacent rows were missing in the output? What's the (24+1) supposed to convey? Are these groups aligned on 25-row boundaries in the whole output (ie, are there an exact multiple of 25 rows before each dropped group)? How are you doing the copies, exactly? SQL COPY command, psql \copy, something else? regards, tom lane