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

[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