On Mon, Apr 15, 2013 at 3:08 PM, Rodrigo Barboza <rodrigombu...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
