Is this not an argument for implementing pagination like I've seen in various GraphQL implementations (among other things), where there is simply something like next=NODE_ID, and then it's selecting LIMIT 15 with a publication date earlier than that NODE_ID, ORDER BY publication_date DESC? Hard to see that having any memory impact.