Bruce Momjian: Will Postgres live forever? – Range Types

Range types. Jonathan Katz is here. He was one of the sort of key people who got excited about range types. I remember a talk he did in Chicago the first time I really understood what range types were for. So if you’re curious about that, find Jonathan Katz and ask him, he’ll love to tell you about it. It is great because it combines a start and stop and a single field that can be easily indexed. The short answer.

Here’s an example of a range type saying give me a car that has a start and stop in this period, using an index.

Watch video from current slide

Share this page: