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
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