#database #tip When you submit a query filtering on functions of an indexed column (date from a timestamp, uppercase of a name, etc.) the index cannot be used, which leads to poor performance. On #postgresql, a solution consists in indexing column evaluations. https://www.postgresql.org/docs/current/sql-createindex.html