| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Paul B(dot) Anderson" <paul(at)pnlassociates(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Large transaction problem |
| Date: | 2004-11-08 23:19:21 |
| Message-ID: | 11721.1099955961@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"Paul B. Anderson" <paul(at)pnlassociates(dot)com> writes:
> I'm trying to move data from an Oracle database into postgresql 7.4.3.
> I have a program that is extracting data and writing it to an sql script
> as a long series of inserts (20,000 at a time). When I run these
> scripts using psql, I occassionally get a problem that is reported as
> ERROR: canceling query due to user request
> And then it won't clear. If I quit psql and start it again, every sql
> statement on that database gives this error after 30 seconds (approx) of
> hanging.
It sounds to me like you are starting the postmaster under finite ulimit
settings --- could be either CPU or filesize limits.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2004-11-08 23:29:43 | Re: using oids as primary keys and foreign keys |
| Previous Message | Paul B. Anderson | 2004-11-08 22:58:12 | Large transaction problem |