Answer the question
In order to leave comments, you need to log in
How to correctly arrange indexes in PostgreSQL (movie database)?
Guys please help with the request.
I decided to transfer the project to PostgreSQL (9.4). But with this base while on "you". I create several indexes, but in one query the index is used and in the other it is not.
Below is a selection, tell me which fields should I put an index on?
genres and countries like how should the gin index be?
Answer the question
In order to leave comments, you need to log in
You would write to begin with what indexes you already have.
Instead of "films", it's better to make a reference to the video content type reference so that this field is an integer, it will work a little faster on a small amount of data and faster on a large one than a string comparison.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question