From: Tom Lane <tgl@sss.pgh.pa.us>
To: Nikola Ivacic <nikola@rs-pi.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: COPY command problems
Date: Tue, 24 Dec 2002 10:24:49 -0500
Message-ID: <19755.1040743489@sss.pgh.pa.us> (raw)
In-Reply-To: <007d01c2ab36$85d92760$1100a8c0@rspi>
References: <007d01c2ab36$85d92760$1100a8c0@rspi>
"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
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, nikola@rs-pi.com
Subject: Re: COPY command problems
In-Reply-To: <19755.1040743489@sss.pgh.pa.us>
* 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