Understanding indexes
I come from the Node.js/MongoDB world and I'm learning Elixir and Ash.
I'm trying to ensure my resources/tables are correctly indexed (using AshPostgres). For that I have the following questions when using Ash:
1. Is the primary
2. If one would like to make a partial index like
3. Is
4. Do I need to use the
Thanks in advance! Looking forward to build something cool with Ash
I'm trying to ensure my resources/tables are correctly indexed (using AshPostgres). For that I have the following questions when using Ash:
1. Is the primary
:id2. If one would like to make a partial index like
[:user_id, :is_active]custom_indexespostgres:user_id:is_active3. Is
identities4. Do I need to use the
custom_indexescreated_atThanks in advance! Looking forward to build something cool with Ash
Solution
1. In Postgres at least, yes. Primary keys get a unique index.
2. This is more of a Postgres question than an ash question, I'd suggest looking at their docs. IIRC you're describing a composite index not a partial one (a partial one would be one with a where clause).
3. Yes. The identities have other uses but they imply a unique constraint and the migration generator will create one
4. Yes, that is how you'd do it
2. This is more of a Postgres question than an ash question, I'd suggest looking at their docs. IIRC you're describing a composite index not a partial one (a partial one would be one with a where clause).
3. Yes. The identities have other uses but they imply a unique constraint and the migration generator will create one
4. Yes, that is how you'd do it
The Elixir backend framework for unparalleled productivity. Declarative tools that let you stop wasting time. Use with Phoenix LiveView or build APIs in minutes for your front-end of choice.
2,193Members
Resources
Similar Threads
Was this page helpful?
