Pdxpug labs

From PostgreSQL wiki

(Difference between revisions)
Jump to: navigation, search
(Ideas for workshops)
Line 23: Line 23:
 
* Foreign Data Wrappers
 
* Foreign Data Wrappers
 
* Benchmarking changes to GUCs, e.g. maintenance_work_mem.
 
* Benchmarking changes to GUCs, e.g. maintenance_work_mem.
 +
* Try out different transaction levels
 
* Try out WAL-E
 
* Try out WAL-E
 
* Admin tools
 
* Admin tools

Revision as of 23:27, 18 March 2014

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 different transaction levels
  • Try out WAL-E
  • Admin tools
    • PgAdminIII
    • PostgreSQL Studio
  • pgbench
  • Connection poolers:
    • pgpool
    • pgbouncer
Personal tools