| From: | Mark Wong <markwkm(at)gmail(dot)com> |
|---|---|
| To: | Postgresql PDX_Users <pdxpug(at)postgresql(dot)org> |
| Subject: | March Meeting 2/19/2009 - eXtreme Database Makeover ep. 2 - PORTAL |
| Date: | 2009-03-17 02:05:21 |
| Message-ID: | 70c01d1d0903161905m5def6c4k4244340e3ba783b1@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pdxpug |
Kristin Tufte will be speaking at the next PDXPUG meeting at FreeGeek
(at 7:00pm -
1731 SE 10th Avenue, Portland, OR).
-----
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
Looking forward to seeing everyone there....and of course, drinks at
the Lucky Lab (http://www.luckylab.com/ ) at 915 SE Hawthorne Blvd.
afterwards.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Wong | 2009-03-17 02:18:23 | Re: March Meeting 3/19/2009 - eXtreme Database Makeover ep. 2 - PORTAL |
| Previous Message | Mark Wong | 2009-03-10 02:53:50 | Performance Testing (P5) Speaker Series - March 12, 7:00 pm |