Re: Deceiding which index to use

От: Mezei Zoltán
Тема: Re: Deceiding which index to use
Дата: ,
Msg-id: 45F18629.4000808@telefor.hu
(см: обсуждение, исходный текст)
Ответ на: Re: Deceiding which index to use  (Richard Huxton)
Ответы: Re: Deceiding which index to use  (Richard Huxton)
Список: pgsql-performance

Скрыть дерево обсуждения

Deceiding which index to use  (Mezei Zoltán, )
 Re: Deceiding which index to use  (Richard Huxton, )
  Re: Deceiding which index to use  (Mezei Zoltán, )
   Re: Deceiding which index to use  (Richard Huxton, )
    Re: Deceiding which index to use  (Mezei Zoltán, )
     Re: Deceiding which index to use  (Richard Huxton, )
      Re: Deceiding which index to use  (Mezei Zoltán, )
       Re: Deceiding which index to use  (Richard Huxton, )
        Re: Deceiding which index to use  (Mezei Zoltán, )
         Re: Deceiding which index to use  (Richard Huxton, )
       Re: Deceiding which index to use  (Alvaro Herrera, )
        Re: Deceiding which index to use  (Mezei Zoltán, )
         Re: Deceiding which index to use  (Richard Huxton, )

<small>Richard Huxton wrote:</small><blockquote cite="mid:"
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 по дате сообщения:

От: Scott Marlowe
Дата:
Сообщение: Re: configuring new server / many slow disks?
От: Andreas Tille
Дата:
Сообщение: PostgreSQL in virtual machine