Pdxpug labs

From PostgreSQL wiki

Revision as of 03:04, 1 March 2014 by Gabrielle (Talk | contribs)

Jump to: navigation, search

Our labs are very informal; think of it like the 'lab time' you used to get in college for extra time on your chemistry projects. We all answer questions and help each other out. You'll pick up tips about postgres, sure, but also system administration, vim, etc. There's an "agenda" of topics we'd like to cover, but you are in no way required to do them in order, or do all of them, and you may certainly add your own.

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