Christophe Pettus: All Your GUCs in a Row: cursor_tuple_fraction (opens in new tab)

The planner assumes cursors fetch only 10% of results by default. If you're actually reading them all, that fast-start bias could be killing your performance.