~/talk

Partitioning and Data Migrations Using PostgreSQL as an Example

on YouTube 34m
TalkinRussianat HighLoad++ 2014 · 2014-10-31..11-01· [databases, data-engineering]

speaker

name:Denis Ivanov
links:none on file

resources

video:https://youtu.be/CJ_qeogG_fg
slides:none on file

summary

Covers partitioning and data migration techniques for PostgreSQL, including automatic data distribution across partitions and performing reads/updates/deletes without changing application code. Describes automatic propagation of partition structures (indexes, constraints, triggers, rules) and workflows for managing large-team migrations of schema objects (procedures, views, tables, types) and deltas, plus the tools and utilities used to implement these processes.

AI-written summary · about

chapters (10)

  1. 0:00Introduction
  2. 4:46Database load problem
  3. 5:49Partitioning by project
  4. 8:23Partition magic tool
  5. 12:03How partition magic works
  6. 14:51Automating partition management
  7. 15:13Data migration challenges
  8. 16:17Migration tool development
  9. 18:53Migration tool benefits
  10. 22:52Q&A

related talks

~/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.