On Thu, Apr 9, 2009 at 4:01 PM, Adam Ray <[email protected]> wrote: > OK, so I changed to the parallel_pg_loader.pl that was in the import_demo > folder and it appears to have started working, but now I get: > > SET > BEGIN > COPY > COPY > COPY > COPY > COPY > COPY > > This has been followed by 2 1/2 hours of 100% CPU usage which is still > running. > Is it working or is something wrong?
It's running the commit. Postgres checks referential integrity constraints at commit time (ref checks are deferred by default) and depending on the speed of the server, the amount of RAM, the configuration of Postgres and the size of the dataset you're loading, it can take a while. --miker > > Adam Ray > SLCC IT Director > > ----- Original Message ----- > From: "Jason Etheridge" <[email protected]> > To: "Evergreen Discussion Group" > <[email protected]> > Sent: Thursday, April 9, 2009 11:08:47 AM GMT -06:00 US/Canada Central > Subject: Re: [OPEN-ILS-GENERAL] MARC Imports > >> So you should enter after you get the # prompt back. > > Enter > > COMMIT; > > that is. > > -- > Jason Etheridge > | VP, Community Support and Advocacy > | Equinox Software, Inc. / The Evergreen Experts > | phone: 1-877-OPEN-ILS (673-6457) > | email: [email protected] > | web: http://www.esilibrary.com > -- Mike Rylander | VP, Research and Design | Equinox Software, Inc. / The Evergreen Experts | phone: 1-877-OPEN-ILS (673-6457) | email: [email protected] | web: http://www.esilibrary.com
