Ciao,
I'm testing 7.2b2 and I see it is much slower when I use like on column
with indexes,
the explain sais it is a sequantial scan (same as 7.1.3), but the time
it get to complete is much longer.
I got the problem only on SMP machine:
explain on 7.1.3 say it is a seq scan with cost 18837
explain on 7.2b2 say it is a seq scan 22.5
on single cpu 7.2b2 says:
Index scan with cost 29 and it is very fast!!
All platform are linux/i386 using redhat 7.2 and latest libraries
I'm testing latest snapshot just now.
thanks
--
-------------------------------------------------------
Giuseppe Tanzilli g.tanzilli@gruppocsf.com
CSF Sistemi srl phone ++39 0775 7771
Via del Ciavattino
Anagni FR
Italy