Ok read about the indexes and type matches. So is this fixed in 8.0?
Thanks, -Prasanth. Tom Lane wrote: > Prasanth <[EMAIL PROTECTED]> writes: > >>code data type is int2. > > > Ah-hah. So "where code > 2::int2" should work noticeably better for > you. Or you could do "where code > '2'" to avoid hard-wiring the data > type knowledge into your queries. Or just change it to int4 ;-) > Or update to 8.0. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
