Re: [HACKERS] Choosing the cheapest optimizer cost

2016-06-21 Thread Bruce Momjian
On Tue, Jun 21, 2016 at 11:17:19AM -0400, Robert Haas wrote: > If the index scans are parameterized by values from the seq scan, > which is likely the situation in which this sort of plan will be > generated, we'll pay the extra cost of building the hash table once > per row in something_big. > >

Re: [HACKERS] Choosing the cheapest optimizer cost

2016-06-21 Thread Robert Haas
On Wed, Jun 15, 2016 at 3:46 PM, Bruce Momjian wrote: > Right now, the optimizer chooses the path with the cheapest cost. > > However, do we take into account the behavior of the plan in handling > mis-estimated row counts? No. > For example, if a path has a log(n) behavior > for changes in the