Regd: TODO Item: Optimizer:: Have EXPLAIN ANALYZE issue NOTICE messages when
the estimated and actual row counts differ by a specified percentage.



Hi,



We are a team of two graduate students (volunteers) who plan to work on the
above problem from the TODO list of the Optimizer. Being new to Postgres, we
plan on following the instructions from the developers FAQ to perform the
necessary changes.



Kindly let us know if you have any other suggestions that we need to keep in
mind?

Also, can anyone give a suggested value of the "Specified Percentage" in the
problem statement of the TO DO list?



We look forward on gathering any essential information form this group.



Thank you,



Ramya

"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

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers