[PERFORM] UNION ALL vs INHERITANCE

2004-12-16 Thread Adi Alurkar
Greetings, Why does the append resulting from a inheritance take longer than one resulting from UNION ALL? summary: Append resulting from inheritance: -> Append (cost=0.00..17.43 rows=2 width=72) (actual time=3.876..245.320 rows=28 loops=1) Append resulting from UNION ALL: -> Append (cost

Re: [PERFORM] UNION ALL vs INHERITANCE

2004-12-16 Thread Tom Lane
Adi Alurkar <[EMAIL PROTECTED]> writes: > Why does the append resulting from a inheritance take longer than one > resulting from UNION ALL? The index scan is where the time difference is: > -> Index Scan using fftiallbgrgfid_1102715649 on > f_f_all_base (cost=0.00..3.