Jonathan S. Katz: Range Types in PostgreSQL 9.2 - Your Life Will Never Be the Same

The range data type is a revolutionary new feature in PostgreSQL 9.2 that gives you the power to search and sieve over any data type that can be represented as a range (and very quickly too!). This talk provides a fundamental overview of range types, how to use them in Postgres, and applications and extensions that they provide. The range data type is a revolutionary new feature in PostgreSQL 9.2 that gives you the power to search and sieve over any data type that can be represented as a range (and very quickly too!). After a brief mathematical refresher of what range types are and how they are represented, we will dive into the different functionalities that PostgreSQL 9.2. After comparing what live was like for such queries before and after the range data type, we will look at some common applications and extensions, and additionally see how VenueBook uses range types in its daily operations.

Length: 49:54

Views 361 Likes: 1

Recorded on 2012-09-17 at Postgres Open

Look for other videos at Postgres Open.

Tweet this video