core dump on select

From: "John Liu" <johnl(at)stihealthcare(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: core dump on select
Date: 2004-09-24 20:55:43
Message-ID: 200409242055.i8OKtuRn025099@mail.stihealthcare.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

AIX pg version 7.4

Select * from document2 core dump. Did a few more experiments with select *
from document2 limit...

I limit to 500000 it works, 600000 it exits but says "calloc: There is not
enough memory available now."

I did a 573600 and it worked, then I did a 573700 and it core dumped. I
went back in and did the search again with 573700 and it then worked.

AIX:

core file size (blocks) 1048575

data seg size (kbytes) unlimited

file size (blocks) unlimited

max memory size (kbytes) 32768

open files 2000

pipe size (512 bytes) 64

stack size (kbytes) 2097151

cpu time (seconds) unlimited

max user processes 1000

virtual memory (kbytes) unlimited

Any thoughts on this? And how to generate the trace?

Thanks.

john

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jay 2004-09-24 21:16:19 inheritance
Previous Message Greg Stark 2004-09-24 20:34:47 Re: [SQL] need ``row number``