Postgres Pro
Downloads
Home   >   mailing lists

Re: Disabling options lowers the estimated cost of a query - Mailing list pgsql-performance

From Tom Lane
Subject Re: Disabling options lowers the estimated cost of a query
Date
Msg-id 4007313.1618578588@sss.pgh.pa.us
Whole thread Raw
In response to Re: Disabling options lowers the estimated cost of a query  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Disabling options lowers the estimated cost of a query  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Disabling options lowers the estimated cost of a query
Next
From: Tom Lane
Date:
Subject: Re: Why is there a tenfold difference between Postgres's alleged query execution time and packet transmission time?