[OPEN-ILS-GENERAL] MARC Imports

[Mike Rylander]

On Thu, Apr 9, 2009 at 4:01 PM, Adam Ray <aray at slcconline.edu> 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" <jason at esilibrary.com>
> To: "Evergreen Discussion Group"
> <open-ils-general at list.georgialibraries.org>
> 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:  jason at esilibrary.com
>  | 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:  miker at esilibrary.com
 | web:  http://www.esilibrary.com