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 F0D2F9FB393 for ; Mon, 11 Sep 2006 16:12:29 -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 20432-03-4 for ; Mon, 11 Sep 2006 16:12:20 -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 C14879FA304 for ; Mon, 11 Sep 2006 16:12:19 -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 k8BJCGPE005559; Mon, 11 Sep 2006 15:12:16 -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 "Mon, 11 Sep 2006 14:55:26 -0400" Date: Mon, 11 Sep 2006 15:12:16 -0400 Message-ID: <5558.1158001936@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/94 X-Sequence-Number: 23008 "Mr. Dan" writes: > We have a table with 12028587 records in it. > We do a COPY TO file of the records for this table. > We count the number of records in the file, it has 12028587 lines. > We do a COPY FROM that file into a table with identical structure as the > first table. > We count the number of records in the second table and there are only > 12028538 records. Try dumping the second table with COPY TO and diff'ing the dump files to get more detail about what's missing. If you repeat the entire experiment, are the same records missing each time? I'm wondering about flaky hardware as much as anything. regards, tom lane