pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Peter Childs <peterachilds@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Fwd: COPY FROM command v8.1.4
Date: Tue, 12 Sep 2006 10:17:04 +0100
Message-ID: <a2de01dd0609120217ncfd2c21l7cdefa5d3cad9154@mail.gmail.com> (raw)
In-Reply-To: <a2de01dd0609120216n1a234dcaqcd3f557a780f172b@mail.gmail.com>
References: <BAY116-F16BCF6E15545D8EFE3AD3FD12A0@phx.gbl>
	<5558.1158001936@sss.pgh.pa.us>
	<a2de01dd0609120216n1a234dcaqcd3f557a780f172b@mail.gmail.com>

Sorry Tom, Somone had not put the reply to header in correctly......

---------- Forwarded message ----------
From: Peter Childs <peterachilds@gmail.com>
Date: 12-Sep-2006 10:16
Subject: Re: [ADMIN] COPY FROM command v8.1.4
To: Tom Lane <tgl@sss.pgh.pa.us>


On 11/09/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Mr. Dan" <bitsandbytes88@hotmail.com> 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



view thread (20+ messages)  latest in thread

Message-ID: <a2de01dd0609120217ncfd2c21l7cdefa5d3cad9154@mail.gmail.com>
Permalink:  ../a2de01dd0609120217ncfd2c21l7cdefa5d3cad9154@mail.gmail.com/
Also on:    postgresql.org/message-id/a2de01dd0609120217ncfd2c21l7cdefa5d3cad9154@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: peterachilds@gmail.com
  Subject: Re: Fwd: COPY FROM command v8.1.4
  In-Reply-To: <a2de01dd0609120217ncfd2c21l7cdefa5d3cad9154@mail.gmail.com>
  References: <BAY116-F16BCF6E15545D8EFE3AD3FD12A0@phx.gbl> <5558.1158001936@sss.pgh.pa.us> <a2de01dd0609120216n1a234dcaqcd3f557a780f172b@mail.gmail.com> <a2de01dd0609120217ncfd2c21l7cdefa5d3cad9154@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox