It all depends at the end of a day, how crucial is that functionality to your app ? If very, I would add to every insert/update a trigger, that would update info on other table(s) with stats per character.
Other option, is to write a function in C that would parse word and chop it in C,O (character, number of occurrences ) result. -- GJ -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
