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

On Mon, 17 May 1999, Tom Lane wrote:

> Date: Mon, 17 May 1999 11:24:31 -0400
> 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)
>
> 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?

No, memory is fine. It just dies.

> Can you provide a backtrace?

Will try to reproduce crash,. How do I can debug psql ?

>
> regards, tom lane
>

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83