Re: Query not using index for user defined type - Mailing list pgsql-hackers

From Jaime Casanova
Subject Re: Query not using index for user defined type
Date
Msg-id CAJKUy5gdewPX2Fs+A=HOv_D39SuY1-kHnBV=O=zAdgqocNxXKQ@mail.gmail.com
Whole thread Raw
In response to Query not using index for user defined type  (Rodrigo Barboza <rodrigombufrj@gmail.com>)
List pgsql-hackers
On Mon, Apr 15, 2013 at 3:08 PM, Rodrigo Barboza
<rodrigombufrj@gmail.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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: COPY and Volatile default expressions
Next
From: Jaime Casanova
Date:
Subject: Re: COPY and Volatile default expressions