~/talk

Proper database staging for Postgres

on YouTube 57m
TalkinRussianat HighLoad++ Moscow 2018 · 2018-11-08..11-09· [databases]

speaker

name:Nikolay Samokhvalov
links:none on file

resources

video:https://youtu.be/rqc-X97ohKE
slides:none on file

summary

Covers proper staging environments for PostgreSQL databases: how to set up and manage staging that reflects production, handle schema and data synchronization, and use PostgreSQL-specific tools and practices to avoid deployment and testing errors.

AI-written summary · about

chapters (14)

  1. 0:00Introduction
  2. 3:38Testing tools overview
  3. 8:38Tool demo
  4. 13:20First experiment setup
  5. 17:42Experiment results analysis
  6. 23:26Cloud experiments
  7. 27:07AWS specifics
  8. 31:26Load collection and replay
  9. 36:00Tool options and parameters
  10. 41:38Load sampling and modeling
  11. 45:40Configuration optimization
  12. 48:27Flame graph results
  13. 51:40Tool installation and usage
  14. 54:48Q&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.