[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

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.52