Re:Why Use Postgres?
by walrus on Sunday April 30, 2017 @11:23PM
(#14235396)
Specifically, here's how that would be done in Postgres:
In a database without range types, it would look like this:
Personally, I don't think range types by themselves are anything special. However, combined with indexes and exclusion constraints, they're really great:
Here's the difference indexes made when retrieving all the scheduling conflicts with a fixed interval (500k rows):
Quite a difference!
[ Parent
| on HN ]
There are no comments on this comment yet.