Loading...

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

445 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Aug 25, 2013

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.

Loading...


to add this to Watch Later

Add to

Loading playlists...