Re: [GENERAL] equivalent of sqlload? - Mailing list pgsql-general

From Michael A. Koerber
Subject Re: [GENERAL] equivalent of sqlload?
Date
Msg-id 199811252129.QAA28150@ll.mit.edu
Whole thread Raw
In response to Re: [GENERAL] equivalent of sqlload?  ("Jeff Hoffmann" <jeff@remapcorp.com>)
List pgsql-general
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
>
>
>


pgsql-general by date:

Previous
From: "Gilley, Charles H."
Date:
Subject: table protections?
Next
From: "PAX!"
Date:
Subject: Re: [GENERAL] Aggregates and Joins