Bruce Momjian <[EMAIL PROTECTED]> writes: > But the strange thing is that LIKE is faster, perhaps meaning his > measurements can't even see the difference,
Yeah, I suspect there's 10% or more noise in these numbers. But then one could read the results as saying we can't reliably measure any difference at all ... I'd feel more confident if the measurements were done using operators repeated enough times to yield multiple-second runtimes. I don't trust fractional-second time measurements on Unix boxen; too much chance of bogus results due to activity of other processes. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])