Re: [HACKERS] GEQO optimizer (was Re: Backend message type 0x44 arrived while idle) - Mailing list pgsql-hackers

From Oleg Bartunov
Subject Re: [HACKERS] GEQO optimizer (was Re: Backend message type 0x44 arrived while idle)
Date
Msg-id Pine.GSO.3.96.SK.990517193708.15218M-100000@ra
Whole thread Raw
In response to Re: [HACKERS] GEQO optimizer (was Re: Backend message type 0x44 arrived while idle)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Obtaining a backtrace (was Re: [HACKERS] GEQO optimizer)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Mon, 17 May 1999, Tom Lane wrote:

> Date: Mon, 17 May 1999 11:24:31 -0400
> From: Tom Lane <tgl@sss.pgh.pa.us>
> To: Oleg Bartunov <oleg@sai.msu.su>
> Cc: pgsql-hackers@postgreSQL.org
> Subject: Re: [HACKERS] GEQO optimizer (was Re: Backend message type 0x44 arrived while idle) 
> 
> Oleg Bartunov <oleg@sai.msu.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@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] GEQO optimizer (was Re: Backend message type 0x44 arrived while idle)
Next
From: Tom Lane
Date:
Subject: Obtaining a backtrace (was Re: [HACKERS] GEQO optimizer)