Automatic DB indexes when Postgresql used as DB backend


we are using Postgresql as DB backend. When I reviewed our DB performance, I realised, that there are almost no DB indexes. Even when relations were defined in Parse (for example relation to _User), the index was not created.

The only indexes that are created are on internal tables - like in _User itself.

What is the best practice to handle indexes in Parse? Do I have to create them manually using SQL? At least indexes in relations could be create automatically…



Yes. Currently you need to create them manually (or use some tool for that). But I agree with you. It would be awesome to have auto-generated indexes in the project.

You can do this after initializing your your Parse Server by accessing your adapter. This example works on both Postgres and Mongo: