On 2020-May-20, Alvaro Herrera wrote:
> > PostgreSQL 13 adds incremental sorting, which accelerates sorting data when
> > existing data in a query is already sorted.
>
> I'm not sure this is very accurate. I would say "incremental sorting,
> which can take advantage of partially sorted data". (Could add more to
> it, "when only a subset of the result set is needed", but that is
> perhaps too many words).
Rereading my suggestion, it's not super helpful either, as it suggests
that it's useful when the data is sorted on disk. I'm coming up with
"which can take advantage of sorted results from intermediate query
steps to speed up subsequent query steps".
Thanks
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services