Le 26 juin 09 à 14:47, Jeremy Kerr a écrit :
For the new function to be faster, we need to know that there are more than 6 (on average, depending on alignment) trailing spaces.
It's becoming somewhat tricky, but maybe the test to do for the optimisation to get used is n >= threshold && str[n-6] == 0x20, àla Boyer/Moore?
I call it tricky because you could have a space here which isn't followed by spaces, but still, if it's not a space here, you're saying we should not even try the optimisation.
-- dim -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers