"Nikola Ivacic" <nikola(at)rs-pi(dot)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