Horton

Re: Disabling options lowers the estimated cost of a query

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Tomas Vondra <tomas.vondra@enterprisedb.com>
Cc: Arne Roland <A.Roland@index.de>, "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Date: 2021-04-16T13:09:48Z
Lists: pgsql-performance 
I wrote:
> ... The code to select the
> right child path would be approximately like get_cheapest_fractional_path,
> except that you need to restrict it to paths with the right sort order.

Duh, I forgot about get_cheapest_fractional_path_for_pathkeys().

			regards, tom lane

Commits

  1. Consider fractional paths in generate_orderedappend_paths