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