Re: "Constraint exclusion" is not general enough
От
Rod Taylor
Тема
Re: "Constraint exclusion" is not general enough
Дата
Msg-id
1154973425.848.120.camel@home
Ответ на
Список
Дерево обсуждения
"Constraint exclusion" is not general enough Tom Lane <tgl@sss.pgh.pa.us>
Re: "Constraint exclusion" is not general enough Hannu Krosing <hannu@skype.net>
Re: "Constraint exclusion" is not general enough Simon Riggs <simon@2ndquadrant.com>
Re: "Constraint exclusion" is not general enough Rod Taylor <pg@rbt.ca>
Re: "Constraint exclusion" is not general enough Tom Lane <tgl@sss.pgh.pa.us>
Re: "Constraint exclusion" is not general enough Rod Taylor <pg@rbt.ca>
Re: "Constraint exclusion" is not general enough "Florian G. Pflug" <fgp@phlo.org>
Re: "Constraint exclusion" is not general enough Tom Lane <tgl@sss.pgh.pa.us>
Re: "Constraint exclusion" is not general enough Rod Taylor <pg@rbt.ca>
Re: "Constraint exclusion" is not general enough "Florian G. Pflug" <fgp@phlo.org>
Re: "Constraint exclusion" is not general enough Tom Lane <tgl@sss.pgh.pa.us>
Re: "Constraint exclusion" is not general enough "Jim C. Nasby" <jnasby@pervasive.com>
Re: "Constraint exclusion" is not general enough Tom Lane <tgl@sss.pgh.pa.us>
Re: "Constraint exclusion" is not general enough stark <stark@enterprisedb.com>
On Mon, 2006-08-07 at 13:44 -0400, Tom Lane wrote: > Rod Taylor writes: > > A simple way of doing this might be to use a minimum cost number? > > But you don't have any cost numbers until after you've done the plan. Isn't it possible to find the cost using the straight forward (fast) method, find out what order of magnitude it is in, then do a second pass with additional planner bells and whistles turned on if the first plan had a high estimate? --
В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата: