Re: Deceiding which index to use

Richard Huxton wrote: <blockquote cite="mid:45F17B70.60001@archonet.com" type="cite"></blockquote><p><font size="2">OK
-so the next place to look is the distribution of values for<br /> subscriber_id on the output_message_log. Does that
havesome subscribers<br /> with many rows and lots with hardly any?</font><small>Hmm... There are about 1.5k
subscriberswith 100-200 messages each - all the other 19k has an average of 8.9 messages, most of them having only 1
message.I think that's exactly the situation you mention...</small><br /><blockquote
cite="mid:45F17B70.60001@archonet.com"type="cite"><p><font size="2">If so, you might need to<br /> increase the stats
onthat column:<br /><br /> ALTER TABLE output_message_log ALTER COLUMN subscriber_id SET STATISTICS<br />
<num>;<br/> ANALYSE output_message_log (subscriber_id);<br /><br /> The <num> defaults to 10, but can be
setas high as 1000. You want to<br /> try and capture the "big" subscribers.<br /></font></blockquote><small>So if I'm
correct:this statistics gathering can be fine tuned, and if i set the <num> to 1000 then not only the first 10
subsribers(with most messages) will be stored in pg_stats, but the first 1000? Is 1000 a hard-coded
highest-possible-value?I think it would be best to set that to simething like 1800-1900 as I have about that many
subsciberswith high message count.<br /><br /> Zizi<br /></small>