sahilpaudel
DB Downtime while indexing a existing record postgres
I have an Elixir application that uses Postgres Db and I want to index a field with a row count of 54K. There are few NULL values as well.
I use Ecto.Migration
def change do
create(index(:rules_engine_test_cases, [:rule_set_version_id]))
end
Will there be any downtime in this case?
Marked As Solved
dimitarvp
No downtime but some queries might be delayed until the indexing finishes.
However, PostgreSQL supports CREATE INDEX CONCURRENTLY for a long time now (at least from 9.6 and on): PostgreSQL: Documentation: 13: CREATE INDEX
Check out the docs of Migration.index – there’s a :concurrently option available.
Also Liked
derek-zhou
Relax, 54K rows are not a whole lot. I bet it finish in seconds.
olivermt
More like milliseconds.
Popular in Questions
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
Practical resources that improve the lives of professional developers. By developers, for developers.
Categories:
Sub Categories:
Forums
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Practical resources that improve the lives of professional developers.
Develop your skills with books, videos, and courses.
Enabling companies to succeed by building software people love.
Courses that'll move you from confusion to "Aha, now I get it!"