On Mon, Oct 30, 2006 at 03:26:09PM +0100, Mattias Kregert wrote: > On the left side it is text, and on the right side it is varchar(10). > Casting left side to varchar(10) does not help, in fact it makes things > even worse: The cast to ::text vanishes in a puff of logic, but the plan > gets bigger and even slower (20-25 seconds).
Casting definitely won't help it any; it was more a question of having the types in the _tables_ be the same. Anyhow, this might be a red herring; others might have something more intelligent to say in this matter. By the way, does it use an index scan if you turn off sequential scans (set enable_seqscan = false)? /* Steinar */ -- Homepage: http://www.sesse.net/ ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
