Re: Optimizer improvements: to do or not to do?

Say42 wrote:
> Perhaps I am wrong but I assume normalization is a usual case, small
> master (parent) tables are not very rare also.
> Yes, my example is unusual but it is _real_ and demonstrate PG
> optimizer inaccuracy. Why don't we make PG optimizer more close to
> reality if we can? Is it so needless and I make a mountain out of a
> molehill?

All you have shown so far is that one particular query runs faster on 
your machine when sequential scans are turned off.  That is certainly a 
problem that is worth addressing.  But you haven't offered any analysis 
about the cause of this problem, so any speculation about 
normalization, usual cases, caching effects and so on are unfounded and 
premature.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/