Re: Deceiding which index to use - Mailing list pgsql-performance

From Mezei Zoltán
Subject Re: Deceiding which index to use
Date
Msg-id 45F18629.4000808@telefor.hu
Whole thread Raw
In response to Re: Deceiding which index to use  (Richard Huxton <dev@archonet.com>)
Responses Re: Deceiding which index to use  (Richard Huxton <dev@archonet.com>)
List pgsql-performance
<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 /> 

pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Deceiding which index to use
Next
From: Mezei Zoltán
Date:
Subject: Re: Deceiding which index to use