From: | "Jeff Hoffmann" <jeff(at)remapcorp(dot)com> |
---|---|
To: | "Michael A(dot) Koerber" <mak(at)ll(dot)mit(dot)edu> |
Cc: | <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [GENERAL] equivalent of sqlload? |
Date: | 1998-11-25 21:18:28 |
Message-ID: | 001501be18b9$260aa200$c525c4ce@remapcorp.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>On Wed, 25 Nov 1998, Jeff Hoffmann wrote:
>
>> you probably ran out of memory for the server process. check out "limit"
>> (or "ulimit") -- you should be able to bump up the datasize to 64m or so
>> (that's what mine is normally set to; i don't think i had to adjust it
for
>> the 5 million record+ table)
>>
>
>>Were am I looking for "limit" or "ulimit"?
>
>mike
sorry -- it's a shell thing. do a man on whatever shell you're using and it
should explain. C shells (and derivatives) use limit; Bourne shells (and
derivatives) use ulimit.
basically just kill the postmaster, run one of these commands, and restart
the postmaster and things should be fine...
for csh/tcsh:
% limit datasize 64m
for sh/bash:
$ ulimit -d 65536
there's also something in one of the FAQ's; search for "palloc" should find
it
jeff
From | Date | Subject | |
---|---|---|---|
Next Message | Gilley, Charles H. | 1998-11-25 21:23:01 | table protections? |
Previous Message | Michael A. Koerber | 1998-11-25 20:46:35 | Re: [GENERAL] equivalent of sqlload? |