Working with timestamps is often incredibly painful, often due to a mix of misunderstanding and other times due to lack of right tooling. This in depth post sets a good context and shows you the two options and when each makes sense in Postgres.
Postgres Vision focuses on current and future enterprise usage of Postgres. This event includes insights from technology and business luminaries, use cases, a look at the Postgres ecosystem, and long-range outlooks from analysts. Visit www.PostgresVision.com.
If you have the need for faceted search in Postgres there’s a number of ways to implement it, this approach uses more of the modern functionality of Postgres: JSONB and GIN Indexes, and throws in full-text search for good measure.
BRIN indexes have been introduced in PostgreSQL 9.5. While BRIN indexes are definitely a win, people tend to exagerate and use them ways too frequently, take a look at when they’re actually most helpful here.