~/talk

My Experience with Embedding PostgresSQL

Talkat PostgresOpen 2013 · 2013-09-16..09-18· [databases, security]
links:none on file
slides:none on file

VMware embeds PostgreSQL across roughly 30 products (about 20 requiring databases) to eliminate external license costs and ships an embedded DB-as-a-service that includes RPM packaging, a service configurator, auto-tuner, a watchdog utility, modified pg_top and a support‑package builder. Real results: dramatic license savings, easier deploys (vCenter Appliance first), but version stickiness, OpenSSL/client library mismatches, occasional crashes from aggressive tuning, and upgrades that require pg_dump/restore or scripted pg_upgrade. Replication is left to application-level or VM-level DR.

AI-written summary · about

  1. 0:00Start
  2. 0:12About me
  3. 1:22The Initial Problem
  4. 2:47Proposal: PostgreSQL?
  5. 4:08Initial Feedback
  6. 6:52Plan: Embedded Default DB
  7. 8:30Ground Work: Migration
  8. 11:58Plan: Backup & Recovery
  9. 13:24Initial Embedded DB Deploymen
  10. 14:53Early Results
  11. 20:15Installation
  12. 22:29Performance related tools
  13. 23:27Related Problems: Crashes
  14. 25:39Availability
  15. 27:19Next Challenge: Supportability
  16. 28:18Usability
  17. 30:13Pluggable UI
  18. 33:35Virtual Appliances
  19. 35:18Upgrades
  20. 37:51Multi-Platform
  21. 38:20PostgreSQL Service on Windows!
  22. 39:32In Closing
~/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.