Network
Join Attendee Network
 

Building Data Warehouses with PostgreSQL

Josh Berkus (PostgreSQL Experts, Inc.)
11:55am Tuesday, 04/12/2011
Data Warehousing and Business Intelligence, PostgreSQL
 Location: Ballroom D
Tags: postgresql, data_warehousing
Average rating: ****.
(4.00, 1 rating)

Has your database grown to hundreds of gigabytes in size, with no limit in sight? Are queries intolerably slow, with some never completing? Are you unable to run UPDATEs and DELETEs against your main tables? Are you considering moving to an expensive proprietary database system do deal with your huge database?

PostgreSQL is an excellent database for small to medium sized data warehouses in the 0.5 to 5 terabyte range. You just need to know a few basic techniques to make your data warehouse more efficient. Large database vetran Josh Berkus will touch on the different areas of knowledge and terminology for data warehouses which you need to know, including:

  • Everything you know about denormalization is wrong
  • Choosing Hardware
  • How to ETL
  • Partitioning and data expiration
  • Time-based data compression
  • EAVil
  • Materialized views
Photo of Josh Berkus

Josh Berkus

PostgreSQL Experts, Inc.

Josh Berkus is primarily known as one of the Core Team of the world-spanning open source database project PostgreSQL. As CEO of PostgreSQL Experts, Inc., he speaks on database and open source topics all over the world, and consults on database design, performance, and open source community building. He also makes pottery and is a darned good cook.

  • EnterpriseDB
  • Amazon Web Services
  • Clustrix
  • Continuent
  • Facebook
  • HTI Consultoria e Tecnologia
  • Monty Program
  • Percona
  • Rackspace Hosting
  • Schooner Information Technology
  • SkySQL
  • Xeround

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Media Partners Opportunities

For media partnerships, contact mediapartners@ oreilly.com

Press & Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

O'Reilly MySQL Conference Bulletin

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference Contacts