X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 368A19FA103 for ; Thu, 14 Sep 2006 10:14:37 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 67325-02 for ; Thu, 14 Sep 2006 13:14:33 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from bay0-omc3-s35.bay0.hotmail.com (bay0-omc3-s35.bay0.hotmail.com [65.54.246.235]) by postgresql.org (Postfix) with ESMTP id A35509FA0C4 for ; Thu, 14 Sep 2006 10:14:33 -0300 (ADT) Received: from hotmail.com ([64.4.38.22]) by bay0-omc3-s35.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 14 Sep 2006 06:14:31 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 14 Sep 2006 06:14:31 -0700 Message-ID: Received: from 64.4.38.200 by by116fd.bay116.hotmail.msn.com with HTTP; Thu, 14 Sep 2006 13:14:29 GMT X-Originating-IP: [66.160.12.211] X-Originating-Email: [bitsandbytes88@hotmail.com] X-Sender: bitsandbytes88@hotmail.com In-Reply-To: <20060913225438.GB2690@cns.vt.edu> From: "Mr. Dan" To: pgsql-admin@postgresql.org Subject: Re: COPY FROM command v8.1.4 Date: Thu, 14 Sep 2006 09:14:29 -0400 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 14 Sep 2006 13:14:31.0165 (UTC) FILETIME=[B6E3C2D0:01C6D7FF] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.907 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, MSGID_FROM_MTA_HEADER, SPF_PASS X-Spam-Level: * X-Archive-Number: 200609/129 X-Sequence-Number: 23043 Hi Ray, I've tried "it" on both WAFL and Reiser filesystems and gotten either 0,1, or 2 blocks of 25 rows missing. I haven't tried it on ext3 or JFS. No, I haven't seen any problems in the syslogs and I haven't seen any drops on the network in regards to WAFL. Reiser is the local filesystem. I'm planning to verify the ctid values today in the missing rows and get back to Tom with information ASAP. ~DjK