3 ms·
Not in the sense that query hints are "hints" to the planner. -O2 means "take more time compiling but produce faster code". This hint will always be valid and
by wulczer 16y ago
Not in the sense that query hints are "hints" to the planner.
-O2 means "take more time compiling but produce faster code". This hint will always be valid and useful, regardless of how the codebase changes. Query planner hints can become obsolete as the data distribution changes.
-fwrapv and -fno-strict-aliasing are correctness settings
-Wxxx are just help for the developers