For booking systems specifically: composite indexes on (date_range, status, venue_id) often outperform single-column indexes by 10-50x. BRIN indexes are also worth exploring if your booking table is append-heavy and date-ordered โ much smaller footprint than B-tree.