Craig Kerstiens put out a tweet the other day, asking:
Whats your favorite hidden gem of Postgres that you wish more people knew about?
The list of resulting hidden gems is... long. Thankfully, he aggregated them in a nice, readable, off-Twitter format. Give it a scan, you're sure to learn something new.