"Brian Hirt" <[EMAIL PROTECTED]> writes: > I have a table with about 1 million rows in it. One of the columns in this > table is some sort of status (it's an int2). Out of the million rows, only > about 100 of the rows have a status that is not like the rest.
> Yes, i do vacuum the table. > > Does anyone know how to avoid all these table scans? Cast the value you're testing against in the query to int2 and you may see an improvement. The planner isn't currently smart enough to realize it can use the index when the test value in the query is an int4. -Doug -- In a world of steel-eyed death, and men who are fighting to be warm, Come in, she said, I'll give you shelter from the storm. -Dylan ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
