Re: Deceiding which index to use

<small>Richard Huxton wrote:</small><blockquote cite="mid:45F182B7.30507@archonet.com"
type="cite"></blockquote><p><fontsize="2">There is a cost to increasing the stats values, otherwise it'd already<br />
beset at 1000. In your case I'm not sure if 100-200 vs 8-9 messages is<br /> enough to skew things. Only one way to
findout...<br /></font><small>Well, I tried. The situation is:<br /><br /> - when I look for a subscriber which the
plannerthinks to have more messages --> it uses the index on crd<br /> - when I look for a subscriber which the
plannerthinks to have less messages --> it uses the index on subscriber_id<br /><br /> I think that's OK, even if it
stilldon't do what I really would like to see it do :-)<br /><br /> Thanks for all your help, maybe I know a little bit
moreabout poostgresql than before.<br /><br /> Zizi</small><br />