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 2B2FB9FA2A9 for ; Tue, 12 Sep 2006 06:17:16 -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 64726-07 for ; Tue, 12 Sep 2006 09:17:08 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.189]) by postgresql.org (Postfix) with ESMTP id 9FAB09FA240 for ; Tue, 12 Sep 2006 06:17:07 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id p77so1454757nfc for ; Tue, 12 Sep 2006 02:17:06 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=I6QxUz9lot42bhsTOmJSZ8PGMdkHlL5B+vwt1yCnAY2mK9IKkzW4sLJ4kRWCUS+h8TsqmMLVxwDzgMhYL72MWMGCqLriJXHA9ypYhnHlmk0ye44na4qmBp4ONj1c6R2cjcLIValohUvorZTRMSJRwhXI1B+k70mVjd0yhPPPqa8= Received: by 10.49.8.4 with SMTP id l4mr9284694nfi; Tue, 12 Sep 2006 02:17:05 -0700 (PDT) Received: by 10.48.213.13 with HTTP; Tue, 12 Sep 2006 02:17:04 -0700 (PDT) Message-ID: Date: Tue, 12 Sep 2006 10:17:04 +0100 From: "Peter Childs" To: pgsql-admin@postgresql.org Subject: Fwd: COPY FROM command v8.1.4 In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <5558.1158001936@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.199 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, SPF_PASS X-Spam-Level: X-Archive-Number: 200609/95 X-Sequence-Number: 23009 Sorry Tom, Somone had not put the reply to header in correctly...... ---------- Forwarded message ---------- From: Peter Childs Date: 12-Sep-2006 10:16 Subject: Re: [ADMIN] COPY FROM command v8.1.4 To: Tom Lane On 11/09/06, Tom Lane wrote: > "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 > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > I presume your doing a select count(*) from table not reading the stats from vacuum verbose or pg_class.... I know it sounds stupid but its a common mistake and vacuum is only a guess Peter Childs