System configuration looks fine to me, there is no upper limit, the only configuration problem a can see is that stacksize limit is set to 512Mb when u only have 256Mb ram, try "limit stacksize 65536" (64Mb) a most serious size, if it does not help I can't be of any more help. If it helps u may need to change hard limit(this is a soft limit) with systune. Regards
----- Original Message ----- From: "Nicolae Mihalache" <[EMAIL PROTECTED]> To: "Luis Alberto Amigo Navarro" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, October 23, 2002 6:09 PM Subject: Re: crashes with postgresql 7.2.1 on IRIX 6.5 > Luis Alberto Amigo Navarro wrote: > > could send the output from: > > limit > > and > > systune | grep shm > > also, what kind of machine is > > regards > > > robust@cassini> limit > cputime unlimited > filesize unlimited > datasize 2097152 kbytes > stacksize 524288 kbytes > coredumpsize unlimited > memoryuse 524288 kbytes > vmemoryuse 2097152 kbytes > descriptors 2500 > threads 1024 > > robust@cassini> systune |grep shm > group: shm (statically changeable) > sshmseg = 2000 (0x7d0) > shmmni = 1064 (0x428) > shmmin = 1 (0x1) > shmmax = 214748365 (0xccccccd) > > robust@cassini> hinv > CPU: MIPS R10000 Processor Chip Revision: 2.7 > FPU: MIPS R10010 Floating Point Chip Revision: 0.0 > 1 195 MHZ IP32 Processor > Main memory size: 256 Mbytes > Secondary unified instruction/data cache size: 1 Mbyte on Processor 0 > Instruction cache size: 32 Kbytes > Data cache size: 32 Kbytes > FLASH PROM version 4.17 > Integral SCSI controller 0: Version ADAPTEC 7880 > Disk drive: unit 2 on SCSI controller 0 > CDROM: unit 4 on SCSI controller 0 > Integral SCSI controller 1: Version ADAPTEC 7880 > Disk drive: unit 5 on SCSI controller 1 > On-board serial ports: tty1 > On-board serial ports: tty2 > On-board EPP/ECP parallel port > CRM graphics installed > Integral Ethernet: ec0, version 1 > Iris Audio Processor: version A3 revision 0 > Video: MVP unit 0 version 1.4 > AV: AV2 Card version 0, Camera not connected. > Vice: TRE > IEEE 1394 High performance serial bus controller 0: Type: OHCI, Version > 0x104C-1 0 > > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html