Pdxpug labs

From PostgreSQL wiki

Revision as of 03:01, 28 February 2014 by Gabrielle (Talk | contribs)

Jump to: navigation, search

Ideas for workshops

  • Replication
    • streaming rep
    • slony
    • bucardo
  • Choosing a High Availability plan
  • Different ways to take backups
  • Troubleshooting slow queries
  • Monitoring (this could easily be a series on its own)
  • Disaster Recovery
  • Oh no, somebody deleted pg_xlog
  • Transaction wraparound
  • Postgres on zfs
  • Postgres packet captures
  • Tour of contrib modules
  • Foreign Data Wrappers
  • Benchmarking changes to GUCs, e.g. maintenance_work_mem.
  • Try out WAL-E
  • Try out PostgreSQL Studio
  • Try out pgbadger (bring your logs!)
  • pgbench
  • pgpool
  • pgbouncer
Personal tools