Can you describe a challenging problem you solved while optimizing PostgreSQL queries for better performance?