Re: Query not using index for user defined type

On Mon, Apr 15, 2013 at 3:08 PM, Rodrigo Barboza
<rodrigombufrj(at)gmail(dot)com> wrote:
>
> Here is the explain analyze with 1000 entries:
>
> explain analyze select * from mytable where a > 120::mytype and a <
> 530::mytype;
>

I'm not sure this is appropiate for -hackers, maybe should post on -general.
Also provide scripts with the creation of the datatype and/or the
OPERATOR FAMILY

anyway, this explain is completely useless to prove your point. if you
are selecting almost half of the table it will use a seq scan. try
again with more rows in the table and a narrow filter

--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
Phone: +593 4 5107566 Cell: +593 987171157