PORTAL is a 900 GB PostgreSQL archive of transportation-related data. Data in portal includes: freeway speed and volume data (received in real-time from the Oregon Department of Transportation), weather data, bus data, accident data, and more. The PORTAL schema was developed years ago and needs to be revamped. Further, PORTAL has performance problems likely caused partly by the fact that it lives on a shared SAN. For this meeting, I.ll show the PORTAL schema as it is now and then we can have some fun tearing it apart and figuring out how it could be improved.