Alexander Korotkov <aekorot...@gmail.com> writes: > 2) An accurate estimate of the sorting cost is quite a difficult task.
Indeed. > What if we make a simple rule of thumb that sorting integers and > floats is cheaper than sorting numerics and strings with collation C, > in turn, that is cheaper than sorting collation-aware strings > (probably more groups)? Within the group, we could keep the original > order of items. I think it's a fool's errand to even try to separate different sort column orderings by cost. We simply do not have sufficiently accurate cost information. The previous patch in this thread got reverted because of that (well, also some implementation issues, but mostly that), and nothing has happened to make me think that another try will fare any better. regards, tom lane