Manual addition of index to DB column (PostgreSQL)

Questions and Answers Database-SQL
1
System Information
  • Strapi Version: 3.6.2
  • Database: PostgreSQL

Hi all,
i’m looking into a way to add an index to a column for a data model i created in Strapi.
I’m aware that using the notation "index":true in the model.json file doesn’t work with Postgres, and that something to overcome this issue is already in the roadmap.

In the meanwhile, I’m thinking about adding the index manually to the needed column in the DB, not going through Strapi.
From the first tests it seems that this operation is transparent to Strapi and that everything keeps working as usual, but i’d like to know from someone that is more knowlegeable than me if you see any drawbacks in doing this.

Thanks!