Re: UNION ALL has higher cost than inheritance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: UNION ALL has higher cost than inheritance
Дата
Msg-id 22347.1287669462@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: UNION ALL has higher cost than inheritance  (Itagaki Takahiro <itagaki.takahiro@gmail.com>)
Ответы Re: UNION ALL has higher cost than inheritance  (Greg Stark <gsstark@mit.edu>)
Список pgsql-hackers
Itagaki Takahiro <itagaki.takahiro@gmail.com> writes:
> On Thu, Oct 21, 2010 at 2:18 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> The plan for UNION initially involves a couple of SubqueryScan nodes,
>> which impose an extra cost of cpu_tuple_cost per tuple.  Those later
>> get optimized away, but we don't try to readjust the cost estimates
>> for that.

> Thanks. It also explains my another question why Merge Append cannot
> be used for UNION ALL plans.

Hmm, seems like the example you show ought to work.  I wonder if there
was an oversight in that patch...
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Marko Tiikkaja
Дата:
Сообщение: Re: Review: Fix snapshot taking inconsistencies
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_rawdump