Re: How does the planner determine plan_rows ?

Поиск
Список
Период
Сортировка
От Donald Dong
Тема Re: How does the planner determine plan_rows ?
Дата
Msg-id AB9055A8-3AC2-4885-B1D5-6DC44451A075@csumb.edu
обсуждение исходный текст
Ответ на Re: How does the planner determine plan_rows ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: How does the planner determine plan_rows ?  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
> On Jan 10, 2019, at 8:01 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> ... estimate_rel_size() in plancat.c is where to look to find out
> about the planner's default estimates when it's lacking hard data.

Thank you! Now I see how the planner uses the rows to estimate the cost and
generates the best_plan.

To me, tracing the function calls is not a simple task. I'm using cscope, and I
use printf when I'm not entirely sure. I was considering to use gbd, but I'm
having issues referencing the source code in gdb.

I'm very interested to learn how the professionals explore the codebase!

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [Sender Address Forgery]Re: error message when subscriptiontarget is a partitioned table
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: [HACKERS] generated columns