Обсуждение: Re: Regd: TODO Item

<p class="MsoNormal" style="MARGIN: 0in 6pt 0pt"><font size="3"><font face="Times New Roman">Regd: TODO Item:
Optimizer::Have EXPLAIN ANALYZE issue NOTICE messages when the estimated and actual row counts differ by a specified
percentage.</font></font><pclass="MsoNormal" style="MARGIN: 0in 6pt 0pt"><font size="3"><font face="Times New
Roman"><spanstyle="mso-spacerun: yes"> </span></font></font><p class="MsoNormal" style="MARGIN: 0in 6pt 0pt"><font
size="3"><fontface="Times New Roman">Hi, </font></font><p class="MsoNormal" style="MARGIN: 0in 6pt 0pt"><font
size="3"><fontface="Times New Roman"><span style="mso-spacerun: yes"> </span></font></font><p class="MsoNormal"
style="MARGIN:0in 6pt 0pt"><font size="3"><font face="Times New Roman"><span style="mso-spacerun: yes"> </span>We are a
teamof two graduate students (volunteers) who plan to work on the above problem from the TODO list of the Optimizer.
Beingnew to Postgres, we plan on following the instructions from the developers FAQ to perform the necessary changes.
</font></font><pclass="MsoNormal" style="MARGIN: 0in 6pt 0pt"><font size="3"><font face="Times New Roman"><span
style="mso-spacerun:yes"> </span></font></font><p class="MsoNormal" style="MARGIN: 0in 6pt 0pt"><font size="3"><font
face="TimesNew Roman">Kindly let us know if you have any other suggestions that we need to keep in mind?
</font></font><pclass="MsoNormal" style="MARGIN: 0in 6pt 0pt"><font size="3"><font face="Times New Roman">Also, can
anyonegive a suggested value of the "Specified Percentage" in the problem statement of the TO DO list? </font></font><p
class="MsoNormal"style="MARGIN: 0in 6pt 0pt"><font size="3"><font face="Times New Roman"><span style="mso-spacerun:
yes"> </span></font></font><pclass="MsoNormal" style="MARGIN: 0in 6pt 0pt"><font size="3"><font face="Times New
Roman">Welook forward on gathering any essential information form this group.</font></font><p class="MsoNormal"
style="MARGIN:0in 6pt 0pt"><font size="3"><font face="Times New Roman"><span style="mso-spacerun:
yes"> </span></font></font><pclass="MsoNormal" style="MARGIN: 0in 6pt 0pt"><font face="Times New Roman" size="3">Thank
you,</font><pclass="MsoNormal" style="MARGIN: 0in 6pt 0pt"><font size="3"><font face="Times New
Roman"> </font></font><pclass="MsoNormal" style="MARGIN: 0in 6pt 0pt"><font face="Times New Roman"
size="3">Ramya</font><p> 

"Ramya Chandrasekar" <csekar.ramya@gmail.com> writes:
> Regd: TODO Item: Optimizer:: Have EXPLAIN ANALYZE issue NOTICE messages when
> the estimated and actual row counts differ by a specified percentage.

I think that TODO item hasn't been thought through very carefully.
NOTICEs that are dissociated from the actual explain output seem pretty
useless, or at least painful to use.  You might want to go back in the
archives and read the whole thread that led up to the TODO item to see
what ideas were kicked around.
        regards, tom lane