[bhahn]

Not a direct answer to your question, but there are two ways that I usually learn about new Postgres features.

1. Through blog posts like this

2. Needing something in the moment and googling.

To elaborate on #2, I learned about partial indices when I was at a situation at work when I needed to optimize indices for a heavily used table. Google eventually brought me to their excellent docs and SO posts that mentioned them.