| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Cc: | "Silvela, Jaime (Exchange)" <JSilvela(at)Bear(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: copy losing information |
| Date: | 2006-07-26 21:05:13 |
| Message-ID: | 18116.1153947913@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Silvela, Jaime (Exchange) wrote:
>> No lines contain quotes. And the same file will sometimes be fully
>> imported, and sometimes lose data. I'm thinking that under heavy loads,
>> the database is discarding INSERTS.
> I don't think that's very likely.
Especially not since he says he's using COPY --- any sort of error would
be all-or-nothing.
Personally I'm wondering about individual rows getting dropped on the
client side.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Redefined Horizons | 2006-07-26 21:17:28 | Table Inheritence...Just Columns? |
| Previous Message | ing_enriquebarrios | 2006-07-26 20:46:13 | Performance Postgresql en HP-UX 11.x |