<html>
<head>
</head>
<body>
I'm sorry, I meant to say 7.2.1 not 7.3 and now I see that it's available.
So I guess I'll go try it and see if it solves my index problem.<br>
<br>
--Maurice<br>
<br>
Maurice Balick wrote:<br>
<blockquote type="cite" cite="mid:3CBC2CD0(dot)4050508(at)smiley(dot)com"> Yes, there
are 42000+ records with order_id = 0, no other order_id is present in more
than 10 records.<br>
<br>
Is there any simple way to solve this problem without going to 7.2? (I'd
rather go to 7.3 directly in a month or two).<br>
<br>
--Maurice<br>
<br>
PS: Thanks for always being there for 'us', the plain users. <br>
<br>
<br>
Tom Lane wrote:<br>
<blockquote type="cite" cite="mid:9810(dot)1018936158(at)sss(dot)pgh(dot)pa(dot)us">
<pre wrap="">Maurice Balick <a class="moz-txt-link-rfc2396E" href="mailto:balm(at)smiley(dot)com"><balm(at)smiley(dot)com></a> writes:<br></pre>
<blockquote type="cite">
<pre wrap="">The weird thing is that this used to work (i.e. trans_oid_idx was used)<br>when there was about 200000 records (about 1/3 of now). Also, there is <br>about<br>9000 distinct values of account_id, but about 300000 values of order_id.<br></pre>
</blockquote>
<pre wrap=""><!----><br>What's the most common value in each case?<br><br></pre>
<blockquote type="cite">
<pre wrap="">(I am running Postgresql 7.1.3 on Redhat 7.1)<br></pre>
</blockquote>
<pre wrap=""><!----><br>7.2 is less likely to be fooled when the most common value is much more<br>common than the rest ...<br><br> regards, tom lane<br><br>---------------------------(end of broadcast)---------------------------<br>TIP 4: Don't 'kill -9' the postmaster<br><br>.<br><br></pre>
</blockquote>
<br>
</blockquote>
<br>
</body>
</html>