Thread

1. Re: [GENERAL] equivalent of sqlload?

   Jeff Hoffmann <jeff@remapcorp.com> — 1998-11-25T21:18:28Z

   >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
   
   
   
   

2. Re: [GENERAL] equivalent of sqlload?

   Michael A. Koerber <mak@ll.mit.edu> — 1998-11-25T21:34:11Z

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