subject:"\[GENERAL\] Subplan and index usage"

Re: [GENERAL] Subplan and index usage

2008-03-13 Thread Tom Lane

"Vyacheslav Kalinin" <[EMAIL PROTECTED]> writes: > [ poor estimation for ] > select * > from cities > where ( ficity_id in ( >select ficity_id from cities_name_words > where fsword like 'novgorod%' > union >select ficity_id from c

[GENERAL] Subplan and index usage

2008-03-12 Thread Vyacheslav Kalinin

Consider the following case which is almost exact snapshot of part of our scheme: Table "cities" Column| Type | Modifiers | Description --++---+- ficity_id| integer| not nu