3,035
edits
Breakpad/WorkWeek: Difference between revisions
Jump to navigation
Jump to search
no edit summary
No edit summary |
|||
| Line 14: | Line 14: | ||
* Develop better/best practices for PostgreSQL | * Develop better/best practices for PostgreSQL | ||
* Performance | |||
* | **pg.conf changes | ||
* | **fs/os changes | ||
* | **query tuning | ||
* | ****monitor | ||
* | ****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 | |||
**(see above) Archiving Discussion | |||
****Implement archiving? | |||
****RRD? | |||
**Data growth analysis | |||
**New feature planning | |||
* Tuesday | |||
**Partitioning | |||
****RRD/Archving? | |||
**Python Check | |||
**Full Text | |||
**Initial Replication | |||
* Wednesday | |||
**Continue replication | |||
**Query analysis etc. | |||
**Capacity planning data | |||
**Bug list and future feature planning | |||
**Interactive query checking | |||
* Thursday | |||
**Capacity Planning session | |||
****Schema changes? | |||
**PHP analysis?* | |||
**Deploy replication? | |||
* Friday | |||
**Query analysis pt.2 | |||
**Troubleshooting | |||
= Travel Schedules = | = Travel Schedules = | ||