6 ms·
Postgres does index de-duplication. So it's likely that even if you change the strings to enums, the index won't be that much smaller. > Furthermore, why have
by hans_castorp 8mo ago
Postgres does index de-duplication. So it's likely that even if you change the strings to enums, the index won't be that much smaller.
> Furthermore, why have two indexes with the same leading field (status)?
That indeed is a valid question.