~/talk

Elasticsearch: Accelerating the Django Admin

Talkat DjangoCon US 2018 · 2018-10-14..10-19· [django, databases]
slides:none on file

Django Admin search migrates from multi‑second queries to near‑instant lookups by sending terms to Elasticsearch, returning ids, and rehydrating via the ORM; production uses elasticsearch‑py not the DSL, versioned indices, and batch updates with Celery beat every two minutes; a problematic migration hit 12 second searches then fell to negligible latency; mappings get dropped and reimported as needed, 1M rows compress to under 100 MB in Elasticsearch.

AI-written summary · about

  1. 0:00Introduction
  2. 0:44About Growth Collaborative
  3. 1:40The Django Admin
  4. 2:54Data Model
  5. 3:09Django Search
  6. 4:22Elasticsearch
  7. 5:11Terminology
  8. 6:44Document ID
  9. 7:14Search
  10. 8:34Get Search Results
  11. 9:00Updating Elasticsearch
  12. 12:24Customer Data Model
  13. 13:03Queries
  14. 13:20Elasticsearch DSL
  15. 15:04Elasticsearch Query
  16. 15:20Elasticsearch Website
  17. 15:36Takeaway
  18. 16:59Elasticsearch Versions
  19. 18:06Testing
  20. 19:58Hosting Options
  21. 23:34Resources
  22. 23:55Django Projects
  23. 25:13Switching from DSL to Pi
  24. 26:33Data Migrations
  25. 30:00Postgres
  26. 31:00Limits
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.