Oh the contortions I've gone through with the query planner to get it not to do things. Also, if you're using JSONB, long strings or other toast entries, your

Oh the contortions I've gone through with the query planner to get it not to do things. Also, if you're using JSONB, long strings or other toast entries, your query plan and your performance will be wildly divorced since the planner doesn't factor in a lot of the toast IO and associated memory management. The lesson for others here is if you have JSONB/long text fields, store them in their own table.