
The machine has 128Meg of RAM, 256Meg of SWAP, and SWAP isn't even being
touched...


acctng=> insert into radhist select * from radhist_old;
FATAL 1:  palloc failure: memory exhausted
acctng=> \q
> pstat -s
Device      1K-blocks     Used    Avail Capacity  Type
/dev/sd0s1b    256000        0   255872     0%    Interleaved
> psql
Welcome to the POSTGRESQL interactive sql monitor:
  Please read the file COPYRIGHT for copyright terms of POSTGRESQL

   type \? for help on slash commands
   type \q to quit
   type \g or terminate with semicolon to execute query
 You are currently connected to the database: acctng

acctng=> select count(start_time) from radhist_old;
 count
------
295850
(1 row)

acctng=>


Tue, 23 Jun 1998 14:10:29 -0400 (EDT)
The Hermit Hacker <scrappy@hub.org>
I thought we had fixed this for v6.3.2 ...?
> 
> 
> The machine has 128Meg of RAM, 256Meg of SWAP, and SWAP isn't even being
> touched...
> 
> 
> acctng=> insert into radhist select * from radhist_old;
> FATAL 1:  palloc failure: memory exhausted

Try this before starting postmaster:

	:
	ulimit -d 65536 2>/dev/null
	ulimit -c 0 2>/dev/null
	limit datasize 64m 2>/dev/null
	limit cordumpsize 0 2>/dev/null

Some proc limit is being exceeded.

> acctng=> \q
> > pstat -s
> Device      1K-blocks     Used    Avail Capacity  Type
> /dev/sd0s1b    256000        0   255872     0%    Interleaved
> > psql
> Welcome to the POSTGRESQL interactive sql monitor:
>   Please read the file COPYRIGHT for copyright terms of POSTGRESQL
> 
>    type \? for help on slash commands
>    type \q to quit
>    type \g or terminate with semicolon to execute query
>  You are currently connected to the database: acctng
> 
> acctng=> select count(start_time) from radhist_old;
>  count
> ------
> 295850
> (1 row)
> 
> acctng=>
> 
> 
> 


-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

Tue, 23 Jun 1998 14:38:02 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] I thought we had fixed this for v6.3.2 ...?
The Hermit Hacker wrote:
> 
> The machine has 128Meg of RAM, 256Meg of SWAP, and SWAP isn't even being
> touched...
> 
> acctng=> insert into radhist select * from radhist_old;
> FATAL 1:  palloc failure: memory exhausted

Size of radhist_old file ?
I'll try to reproduce...

Vadim

Wed, 24 Jun 1998 03:02:42 +0800
Vadim Mikheev <vadim@krs.ru>
Re: [HACKERS] I thought we had fixed this for v6.3.2 ...?
On Wed, 24 Jun 1998, Vadim Mikheev wrote:

> The Hermit Hacker wrote:
> > 
> > The machine has 128Meg of RAM, 256Meg of SWAP, and SWAP isn't even being
> > touched...
> > 
> > acctng=> insert into radhist select * from radhist_old;
> > FATAL 1:  palloc failure: memory exhausted
> 
> Size of radhist_old file ?
> I'll try to reproduce...

palos> ls -lt radhist_old
-rw-------  1 pgsql  wheel  40198144 Jun 23 13:11 radhist_old

~300 000 tuples ...



Tue, 23 Jun 1998 15:04:04 -0400 (EDT)
The Hermit Hacker <scrappy@hub.org>
Re: [HACKERS] I thought we had fixed this for v6.3.2 ...?
On Tue, 23 Jun 1998, Bruce Momjian wrote:

> > 
> > 
> > The machine has 128Meg of RAM, 256Meg of SWAP, and SWAP isn't even being
> > touched...
> > 
> > 
> > acctng=> insert into radhist select * from radhist_old;
> > FATAL 1:  palloc failure: memory exhausted
> 
> Try this before starting postmaster:
> 
> 	:
> 	ulimit -d 65536 2>/dev/null
> 	ulimit -c 0 2>/dev/null
> 	limit datasize 64m 2>/dev/null
> 	limit cordumpsize 0 2>/dev/null
> 
> Some proc limit is being exceeded.

	Just an FYI...this did fix it.  Should we update the FAQ with
this, or was it already there and I couldn't find it? :(

> 
> > acctng=> \q
> > > pstat -s
> > Device      1K-blocks     Used    Avail Capacity  Type
> > /dev/sd0s1b    256000        0   255872     0%    Interleaved
> > > psql
> > Welcome to the POSTGRESQL interactive sql monitor:
> >   Please read the file COPYRIGHT for copyright terms of POSTGRESQL
> > 
> >    type \? for help on slash commands
> >    type \q to quit
> >    type \g or terminate with semicolon to execute query
> >  You are currently connected to the database: acctng
> > 
> > acctng=> select count(start_time) from radhist_old;
> >  count
> > ------
> > 295850
> > (1 row)
> > 
> > acctng=>
> > 
> > 
> > 
> 
> 
> -- 
> Bruce Momjian                          |  830 Blythe Avenue
> maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
>   +  If your life is a hard drive,     |  (610) 353-9879(w)
>   +  Christ can be your backup.        |  (610) 853-3000(h)
> 

Marc G. Fournier                                
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 


Sat, 27 Jun 1998 20:17:39 -0300 (ADT)
The Hermit Hacker <scrappy@hub.org>
Re: [HACKERS] I thought we had fixed this for v6.3.2 ...?
> 
> On Tue, 23 Jun 1998, Bruce Momjian wrote:
> 
> > > 
> > > 
> > > The machine has 128Meg of RAM, 256Meg of SWAP, and SWAP isn't even being
> > > touched...
> > > 
> > > 
> > > acctng=> insert into radhist select * from radhist_old;
> > > FATAL 1:  palloc failure: memory exhausted
> > 
> > Try this before starting postmaster:
> > 
> > 	:
> > 	ulimit -d 65536 2>/dev/null
> > 	ulimit -c 0 2>/dev/null
> > 	limit datasize 64m 2>/dev/null
> > 	limit cordumpsize 0 2>/dev/null
> > 
> > Some proc limit is being exceeded.
> 
> 	Just an FYI...this did fix it.  Should we update the FAQ with
> this, or was it already there and I couldn't find it? :(

Added to the FAQ.

-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

Sat, 27 Jun 1998 22:14:10 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] I thought we had fixed this for v6.3.2 ...?