March Meeting 2/19/2009 - eXtreme Database Makeover ep. 2 - PORTAL

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.

and FYI - we're having a special guest from Seattle come visit.

Everyone, be especially good. :)

Also, I'll bring a projector to avoid any unpleasantness. Would appreciate
people reminding me to bring it. :)

On Mon, Mar 16, 2009 at 7:05 PM, Mark Wong <markwkm(at)gmail(dot)com> wrote:

> 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.
>
> --
> Sent via pdxpug mailing list (pdxpug(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pdxpug
>

--
Selena Deckelmann
Open Source Bridge - http://www.opensourcebridge.org
PDXPUG - http://pugs.postgresql.org/pdx
Me - http://www.chesnok.com/daily