Thread: Re: [GENERAL] equivalent of sqlload?

Re: [GENERAL] equivalent of sqlload?

From
"Jeff Hoffmann"
Date:
>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



Re: [GENERAL] equivalent of sqlload?

From
"Michael A. Koerber"
Date:
Thanks.  The defaults for my system are
mak> ulimit -a
core file size (blocks)  1000000
data seg size (kbytes)   unlimited
file size (blocks)       unlimited
max memory size (kbytes) unlimited
stack size (kbytes)      8192
cpu time (seconds)       unlimited
max user processes       256
pipe size (512 bytes)    8
open files               256
virtual memory (kbytes)  2105343

Seems that these should be okay.

Ideas?
tnx,

mike

On Wed, 25 Nov 1998, Jeff Hoffmann wrote:

> >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
>
>
>