Building Data Warehouses with PostgreSQL

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

Media Partners Opportunities

For media partnerships, contact mediapartners@

Press & Media

For media-related inquiries, contact Maureen Jennings at

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