Optimize newposterwall queries to leverage partitioning