| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | "Silvela, Jaime (Exchange)" <JSilvela(at)Bear(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: copy losing information |
| Date: | 2006-07-26 20:38:39 |
| Message-ID: | 20060726203838.GB10799@surnet.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
How are you checking that the data is there? Do you check the whole
table by way of a big, fat, unconstrained SELECT, or do you extract some
rows one by one? My guess would be that maybe some insertions are not
making it into an index that may be later used for getting the data
during the examination.
If there are no indexes involved (no primary key either) then this
theory can be discarded quickly.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ing_enriquebarrios | 2006-07-26 20:46:13 | Performance Postgresql en HP-UX 11.x |
| Previous Message | Reece Hart | 2006-07-26 20:38:38 | Re: copy losing information |