Return-Path: owner-postman
Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id VAA21589 for postgres-redist; Mon, 6 Feb 1995 21:26:19 -0800
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199502070526.VAA21589@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from faerie.CS.Berkeley.EDU (faerie.CS.Berkeley.EDU [128.32.37.53]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with ESMTP id VAA21579 for <postgres@postgres.Berkeley.EDU>; Mon, 6 Feb 1995 21:26:19 -0800
Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by faerie.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id VAA23241; Mon, 6 Feb 1995 21:26:02 -0800
Message-Id: <199502070526.VAA23241@faerie.CS.Berkeley.EDU>
X-Authentication-Warning: faerie.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol
From: aoki@cs.berkeley.edu (Paul M. Aoki)
To: David Bigagli <david@naxos.caspur.it>
Cc: postgres@postgres.Berkeley.EDU
Subject: Re: problems with memory 
Reply-To: aoki@cs.berkeley.edu (Paul M. Aoki)
In-reply-to: Your message of Sun, 5 Feb 1995 16:54:01 +0100 
	     <9502051554.AA02667@naxos.caspur.it> 
Date: Mon, 06 Feb 95 21:26:02 -0800
X-Sender: aoki@postgres.Berkeley.EDU
Resent-To: postgres-redist@postgres.Berkeley.EDU
X-Mts: smtp
Resent-Date: Mon, 06 Feb 95 21:26:19 -0800
Resent-XMts: smtp

David Bigagli <david@naxos.caspur.it> writes:
>  Installation was ok. We found problems using copy command with a ascii file
>  which dimension is 89373089 bytes. After two houres the copy aborts
>  with the message "FATAL 1:Feb  4 22:54:39:palloc failure: memory exhausted".

you're likely hitting process virtual memory limits (based on
available swap space).  each copy command runs in one transaction and
some types of memory are only freed between transactions.

i would try splitting the file into smaller chunks and loading them
with separate copy commands.
--
  Paul M. Aoki          |  University of California at Berkeley
  aoki@CS.Berkeley.EDU  |  Dept. of EECS, Computer Science Division (#1776) 
                        |  Berkeley, CA 94720-1776

==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================
              URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/