Re: 7.2b2 problem using like 'XXX%' sequential scan

Yes, I vacuumed/reindexed the db,
just tested the latest snapshot, same problem.

bye

Antonio Fiol Bonnín wrote:

>Did you VACUUM ANALYZE on your SMP machine?
>
>Antonio
>
>Giuseppe Tanzilli - CSF wrote:
>
>>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(dot)tanzilli(at)gruppocsf(dot)com
>>CSF Sistemi srl phone ++39 0775 7771
>>Via del Ciavattino
>>Anagni FR
>>Italy
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 5: Have you checked our extensive FAQ?
>>
>>http://www.postgresql.org/users-lounge/docs/faq.html
>>
>
>

--
-------------------------------------------------------
Giuseppe Tanzilli g(dot)tanzilli(at)gruppocsf(dot)com
CSF Sistemi srl phone ++39 0775 7771
Via del Ciavattino
Anagni FR
Italy