I have a postgresql DB in which I do a lot of string matching ala :
UPDATE table1 SET colum1 = TRUE WHERE colum2 LIKE '%teststring%';
colum2 is a whole html file
As I said I do A LOT of this and I'm looking for a CPU that can do this faster. Because my understanding is that the pattern matching is mostly CPU bound. So which CPU benchmark targets this kind of workload?