-- table size: 1117 MB
-- regex index size: 1727 MB (big index = disadvantage)

  where txt like '%batman%'; -->  'like' means: search without regex; uses the trgm index
                                      txt                                        
---------------------------------------------------------------------------------
 zdfrcj batman igihbky bpwz hzzfmq plyazufcawovvjrlwow xkllfiovgktraw  bmnuyjelj

Time: 9.911 ms

  where txt ~ '\ybatman\y'; -->  '~' means: regex search;  \y:  word boundary
                                      txt                                        
---------------------------------------------------------------------------------
 zdfrcj batman igihbky bpwz hzzfmq plyazufcawovvjrlwow xkllfiovgktraw  bmnuyjelj

Time: 13.179 ms