PostgreSQL is able to let you index just a subset of your data if that's what your application in interested in. The feature is called partial indexes and it allows you to essentially add a where clause to your indexes. Chris Erwin shares some of his experience and talks about this incredibly powerful tool, which is something he says most developers don't know about. In his lightning talk, Chris covers what partial indexes are, how to use them, and some practical real world examples.
Chris is cofounder of Elemeno, a modern cloud-based Content Management System. Previously he was lead developer for the world renowned design agency Teehan+Lax where he worked on high-profile projects for Medium, YouTube, Google, Flipboard, and many others. He's passionate about creating beautifully crafted experiences that solve complex problems in simple ways. He tackles all aspects of product development including front-end, back-end, and infrastructure development, as well as UI design.
If you have any feedback about this or any other Compose article, drop the Compose Articles team a line at email@example.com. We're happy to hear from you.