Pdxpug labs

From PostgreSQL wiki

Revision as of 23:00, 28 February 2014 by Gabrielle (Talk | contribs)

Jump to: navigation, search

Ideas for workshops

  • Replication
  • Choosing a High Availability plan
  • Different ways to take backups
  • Troubleshooting slow queries
  • Monitoring (this could easily be a series on its own)
    • check_postgres
    • Try out pgbadger (bring your logs!)
  • 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
  • Admin tools
    • PgAdminIII
    • PostgreSQL Studio
  • pgbench
  • Connection poolers:
    • pgpool
    • pgbouncer
Personal tools