What's That Noise?! [Ian Kallen's Weblog]

« CardSpace and the... | Main | Counting Links To... »

Wednesday November 15, 2006

Scaling PostgreSQL

Last night, Casey Duncan gave a nice presentation on how Pandora partitions and populates their PostgreSQL data warehouse. The San Francisco PostgreSQL Users Group meeting discussion, Horizontal Scalability with Postgresql: A Case Study, covered how Pandora segments their data set, uses pgpool connection aggregation and Slony for replication and log shipping. I also had great conversation with Greenplum CTO Luke Lonergan, they're definitely pushing the envelope of what's possible with open source database technologies. Kudos to Pandora and Greenplum, great stuff.

postgresql greenplum pandora slony pgpool datawarehousing

( Nov 15 2006, 10:50:56 AM PST ) Permalink

Comments:

Technorati

Who?

I'm Ian Kallen. I'm an entrepreneur and technologist working on Blockboard. My technical interests are focused on mobile, location, cloud computing, big data, real time event systems, search, devops and agile web application code. I'm a long time open source enthusiast and enjoy right-sizing code architecture and infrastructure with the scope and stage a technology startup is operating at.

Previously, I was an independent technology consultant. Prior to that, I did a long stint with Technorati leading the Core Services engineering group in architecting a backend to support search and exploring the web as it changes in real time. I have an eclectic background in technology, publishing, social software and ... life. I like to think: well rounded. I have been online participating in virtual communities since 1988 and developing online resources, services and systems as well as enterprise software since 1991. Once in a while, I have time and inspiration to blog.

The views expressed here are not necessarily those of any present or past employers. KTHXBAI

Feed: