sahilpaudel
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?
Where Next?
Trending in Questions
Other Trending Topics
Latest on Elixir Forum
Sponsor Spotlight
Producing high quality Elixir screencasts since 2017.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #elixirconf
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #blog-post
- #phoenix_html
- #iex
- #graphql
- #ai
- #genstage
- #elixirconf-us
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #metaprogramming
- #security
- #hex
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.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Practical resources that improve the lives of professional developers.
Develop your skills with books, videos, and courses.
The deployment platform built for Elixir: PaaS ease, VPS control.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
First 3 of 3 Posts
dimitarvp
No downtime but some queries might be delayed until the indexing finishes.
However, PostgreSQL supports
CREATE INDEX CONCURRENTLYfor a long time now (at least from 9.6 and on): PostgreSQL: Documentation: 13: CREATE INDEXCheck out the docs of
Migration.index– there’s a:concurrentlyoption available.derek-zhou
Relax, 54K rows are not a whole lot. I bet it finish in seconds.
olivermt
More like milliseconds.