Hi,<div><br></div><div>Please find attached a query (and corresponding schema) that results in mserver5 using more than 1GB of memory and terminating after 6 mins with this output:</div><blockquote style="margin:0 0 0 40px;border:none;padding:0px">


<div><br></div><div><div><div>MAPI  = (monetdb) /tmp/.s.monetdb.50000</div><div>ACTION= read_line</div><div>QUERY = PLAN SELECT DISTINCT </div><div>        <span style="white-space:pre-wrap">	</span>h3.obj, </div>
<div>        <span style="white-space:pre-wrap">	</span>CASE </div><div>        <span style="white-space:pre-wrap">		</span>WHEN u_ENDPOINT.value IS NOT NULL THEN u_ENDPOINT.value </div>
<div>        <span style="white-space:pre-wrap">		</span>WHEN l_ENDPOINT.value IS NOT NULL THEN l_ENDPOINT.value </div><div>        <span style="white-space:pre-wrap">		</span>WHEN ll_ENDPOINT.value IS NOT NULL THEN ll_ENDPOINT.value </div>

<div>        <span style="white-space:pre-wrap">		</span>WHEN lu_ENDPOINT.value IS NOT NULL THEN lu_ENDPOINT.value </div><div>        <span style="white-space:pre-wrap">	</span>END, </div>
<div>        <span style="white-space:pre-wrap">	</span>NULL</div><div>        FROM </div><div>        <span style="white-space:pre-wrap">	</span>triples t0 </div><div>        <span style="white-space:pre-wrap">	</span>INNER JOIN triples h1 ON (h1.pred = 21 AND h1.obj = 42 AND h1.subj = t0.subj) </div>

<div>        <span style="white-space:pre-wrap">	</span>INNER JOIN triples h2 ON (h2.pred = 5 AND h2.subj = t0.subj) </div><div>        <span style="white-space:pre-wrap">	</span>INNER JOIN triples h3 ON (h3.pred = 20 AND h3.subj = t0.s</div>

<div>ERROR = !Connection terminated</div></div></div></blockquote><div><br></div><div><br></div><div>Is it a problem of optimizer?</div>
<div>Any guidelines to deal with it will be appreciated.</div><div><br></div><div>I also attached merovigian.log.</div><div><br clear="all"><br>-- <br>George Garbis<br>
</div>