Re: [HACKERS] GEQO optimizer (was Re: Backend message type 0x44 arrived while idle)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] GEQO optimizer (was Re: Backend message type 0x44 arrived while idle)
Date: 1999-05-17 15:24:31
Message-ID: 9524.926954671@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> writes:
> it seems that was my fault, I didn't specified @nitems (sizes of tables)
> for all tables. Now it works fine.
> Tom, in case of my fault, why did postgres die ?

I don't know --- I don't see it here. I just ran your script as given,
and it worked. (It produced zero rows of output, since the missing
nitems values meant that no data was loaded into the last few tables ...
but there was no backend crash.)

Is it crashing because of running out of memory, or something else?
Can you provide a backtrace?

regards, tom lane

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message José Soares 1999-05-17 15:28:39 Re: [SQL] Oddities with NULL and GROUP BY
Previous Message Tom Lane 1999-05-17 14:49:51 Re: [HACKERS] GEQO optimizer (was Re: Backend message type 0x44 arrived while idle)