Optimize various RSS queries to leverage partitioning