Partial functional indexes are amazing. You can create an index that not only elides execution of the function, but automatically only includes the subset where

Partial functional indexes are amazing. You can create an index that not only elides execution of the function, but automatically only includes the subset where that function would be relevant. Makes the index smaller, to boot. create index repo_name_lower on repos(LOWER(name)) where name IS NOT NULL;