In our last post we described one of our Q4 goals as:
work with PostgreSQL to update and optimize our hardware and software configurations
Aravind has gone ahead and migrated the Socorro database to its new hardware and we’ve upgraded PostgreSQL to 8.3 in order to take advantage of performance optimizations that went into the most recent release. We’ve also updated the configuration so xlogs and logs are written to a different data store than the main database.
Unfortunately this required a full migration over the weekend, which required some downtime. This morning we are running a full vacuum which will also take a considerable amount of time to finish. There is no ETA, but we will post an update when it is completed.
Update: We have postponed the full vacuum/analyze until a maintenance window later this week — it has taken way too long to complete and can’t afford to lock tables for this long.