Re: COPY command problems

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: COPY command problems
Дата
Msg-id 19755.1040743489@sss.pgh.pa.us
обсуждение исходный текст
Ответ на COPY command problems  ("Nikola Ivacic" <nikola@rs-pi.com>)
Список 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 по дате отправления:

Предыдущее
От: "Nikola Ivacic"
Дата:
Сообщение: COPY command problems
Следующее
От: "Nikola Ivacic"
Дата:
Сообщение: Re: COPY command problems