Michael Loftis <[EMAIL PROTECTED]> writes: > Realistically the system should choos *ANY* index over a sequential > table scan.
Sorry, I do not accept that. You might as well say that we should rip out any attempt at cost estimation, and instead put in two or three lines of brain-dead heuristics. If it were that simple we'd all be using MySQL ;-) > Above a fairly low number of records any indexed query > should be much faster than a seqscan. Isn't that exactly backwards? regards, tom lane ---------------------------(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