Pdxpug labs

Our labs are very informal and do not have a set agenda or leader. We *may* have an list 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. We all answer questions and help each other out.

The objective is to mess around with Pg-related stuff in a more relaxed environment than you may have at work. And on non-production equipment. :)

Ideas for workshops

• Schemaverse! https://schemaverse.com/
• Replication
  • BDR (Dec 2014)
  • streaming rep (Jan & Feb 2014)
    • group project: flowchart of all the different options & pieces parts
    • try this: https://github.com/darkixion/pg_rep_test
  • slony
  • bucardo
• Choosing a High Availability plan
• Upgrading
  • old-school pgdump, binary or plain
  • Slony
  • pg_upgrade
• 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 (Jan 2015)
• Try out different transaction levels
• Inheritance
• Row-level security
• Try out WAL-E
• Admin tools
  • PgAdminIII
  • PostgreSQL Studio
• Perf testing
  • pgbench
  • pgreplay https://github.com/laurenz/pgreplay
  • Benchmarking changes to GUCs, e.g. maintenance_work_mem.
• Connection poolers:
  • pgpool
  • pgbouncer
• Contrib modules:
  • tablefunc (crosstab!)