Christophe Pettus: All Your GUCs in a Row: enable_incremental_sort
https://postgr.es/p/9ny
#postgresql
Incremental sort exploits presorted data to avoid expensive full sorts, but cost estimation errors on skewed data can backfire.
Planet PostgreSQL