Re: Deceiding which index to use

From: Mezei Zoltán
Subject: Re: Deceiding which index to use
Date: ,
Msg-id: 45F174CF.8010302@telefor.hu
(view: Whole thread, Raw)
In response to: Re: Deceiding which index to use  (Richard Huxton)
Responses: Re: Deceiding which index to use  (Richard Huxton)
List: pgsql-performance

Tree view

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 by date:

From: Scott Marlowe
Date:
Subject: Re: configuring new server / many slow disks?
From: Andreas Tille
Date:
Subject: PostgreSQL in virtual machine