Re: COPY command problems - Mailing list pgsql-sql

From Tom Lane
Subject Re: COPY command problems
Date
Msg-id 19755.1040743489@sss.pgh.pa.us
Whole thread Raw
In response to COPY command problems  ("Nikola Ivacic" <nikola@rs-pi.com>)
List pgsql-sql
"Nikola Ivacic" <nikola@rs-pi.com> writes:
> Has somebody experienced difficulties using COPY command on large files.
> I have a large (250MB) file and each time I insert records I've got one or =
> more (< 30 of cca 1079000) corrupted
> records. The number of corrupted records is not constant (i.e. 1, 30, 7, 23=
>  etc..)

I'd bet on flaky hardware --- have you run memory and disk tests?  If
the COPY data is passing across a network, then network problems are
also worthy of suspicion.
        regards, tom lane


pgsql-sql by date:

Previous
From: "Nikola Ivacic"
Date:
Subject: COPY command problems
Next
From: "Nikola Ivacic"
Date:
Subject: Re: COPY command problems