DataLayer: Partial Indexing for Improved Query Performance


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 We're happy to hear from you.

Thom Crowe
Thom Crowe was a marketing and community guy at Compose, who enjoys long walks on the beach, reading, spending time with his wife and daughter and tinkering. Love this article? Head over to Thom Crowe’s author page to keep reading.

Conquer the Data Layer

Spend your time developing apps, not managing databases.