Re: Deceiding which index to use

От: Mezei Zoltán
Тема: Re: Deceiding which index to use
Дата: ,
Msg-id: 45F174CF.8010302@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><font face="Tahoma">Richard Huxton wrote:<br /> > Mezei Zoltán wrote:<br /> > Q1. Why are you storing a
numericin a varchar?<br /><br /> Because it's not always numeric info. :/<br /><br /> > Q2. How many unique values
doesanumber have? And how many rows in<br /> > subscriber?<br /><br /> About 10k distinct anumbers and 20k rows.
Nothingspecial...<br /><br /> > Q3. What happens if you create the index on plain (anumber) and then<br /> > test
against'555555555'?<br /><br /> Nothing, everything is the same - the problem lies on the other table's index usage,
usingthis index is fine.<br /><br /> Zizi</font><font face="Tahoma"></font><br /></small> 

В списке pgsql-performance по дате сообщения:

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