~/talk

Efforts Toward Adoption and Uncovering Hidden Features

TalkinJapaneseat Distributed SQL Summit Asia 2024 · on Wednesday, 2024-04-24· [databases, web-platform]
links:none on file
slides:none on file

NTT Data pilots YugabyteDB to build a spatio-temporal pipeline: Spark pre-processes mobility data and inserts it into YugabyteDB using PostGIS support. Tests show a packed-row storage format yields much higher insert+read throughput, and the cloud migration aims for ~100k read QPS, ~100k writes, tens of TB of data, 1s tail latency and zero planned downtime; noted Yugabyte engine features include a rule-based optimizer, Postgres-compatible read-committed semantics, work-in-progress atomic DDL, built-in connection pooling, and bitmap scans.

AI-written summary · about

  1. 0:00Introduction
  2. 0:25NTT Data’s distributed DB efforts
  3. 1:32YB Database for spatiotemporal data
  4. 2:59Cloud drift case study
  5. 5:23YB Database’s 3 motivations
  6. 6:28YB Database’s hidden features
  7. 6:49Rule-based optimizer traits
  8. 9:23Read committed benefits
  9. 11:48Migration benefits of isolation
  10. 12:50AtomicDDL for ops
  11. 13:32Packed row storage
  12. 16:47Packed row flexibility
  13. 17:10PostgreSQL extensions in YB DB
  14. 19:22Custom extensions for YB DB
  15. 20:263 standout YB Database features
  16. 24:20Summary
~/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.