* Develop better/best practices for PostgreSQL
= Monday =* Performance**pg.conf changes**fs/os changes**query tuning* Orientation, introductions, goals***monitor* Access to everything ***reports****interactive query tuning******memory checks**index/schema check**performance monitoring****install tools****check results**re-tuning & hw recommendations**application performance check****monitor/processor -- python****reporting -- php **full text for signatures* Failover**Uptime requirements**Prepare failover plan**Failover config & scripts* Partitioning**Partition scheme check**Check for bad queries**Rolloff plans**Deal with archive partition* IT Admin**Monitoring -- plans****Implementation**Backup & Redundancy plan****Implementation* Capacity Planning**(ITsee above)Archiving Discussion* Report from IT on environments***Implement archiving?* Discuss hardware, optimization***RRD?* Database optimization, structure*Data growth analysis**New feature planning= * Tuesday =* Software and query optimization*Partitioning****RRD/Archving?**Python Check**Full Text**Initial Replication* How to use explain properlyWednesday* Discuss *Continue replication options, splitting workload away from operational DB**Query analysis etc.**Capacity planning data= Wednesday =**Bug list and future feature planning**Interactive query checking* Thursday**Capacity Planning session* Database normalization (whiteboard) -- need more***Schema changes? less**PHP analysis?* * Future schema changes*Deploy replication?* Friday= Thursday =**Query analysis pt.2= Friday =**Troubleshooting
= Travel Schedules =
